# Solved How to write excel formula

March 10, 2020 at 07:27:35
Specs: Windows 10
 I need an excel formula that will add 90 days to adate if another cell says yes or no. Example Column B has a Yes or a No Column C has a date column E needs to add 90 days to the date in Column C if the answer in column B is a no

See More: How to write excel formula

#1
March 10, 2020 at 07:37:28
 What do you want returned if Column B doesn't contain "No"? If you don't tell the formula what to return, it will return the word FALSE.Assuming you want a blank cell for anything other than No, try this:=IF(B1="No",C1+90,"")Be sure to format the cells in Column E so that they display a date.

#2
March 15, 2020 at 02:23:03
 =IF(B:B="Yes",C:C+90,C:C+0)copy paste this to any cell in the E row, it should output the result in the cell in the E row. now it display both dates tho..

#3
March 15, 2020 at 07:42:49
 re: "copy paste this to any cell in the E row"E is a column, not a row.re: "=IF(B:B="Yes",C:C+90,C:C+0)"OP wants to add 90 if Column B contain No, not Yes.In addition, why force Excel to add 0 to the original value? It would be more efficient to use:=IF(B:B="No",C:C+90,C:C)

Related Solutions

#4
March 15, 2020 at 16:16:01
 oh i misread.thanks for correcting.adding 0 or not result should be the same tho