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.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

#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..


Report •

#3
March 15, 2020 at 07:42:49
✔ Best Answer
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)

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

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


Report •

#5
March 16, 2020 at 03:41:13
Yes, the result will be the same, but adding zero is a waste of resources and makes the formula harder to read.

We could write all sorts of formulas that will return the "same result" but we should always strive to use the most efficient methods.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

Ask Question