Solved I need to say if cell A2=yes,Then,cell A3=EDATE(A1,3)

February 4, 2015 at 06:08:15
Specs: Windows 7
so to be clear, I have a cell that says yes, or is blank. If it says yes, I need to calculate a date 3 months ahead

See More: I need to say if cell A2=yes,Then,cell A3=EDATE(A1,3)

Report •

#1
February 4, 2015 at 07:22:04
What do you want the formula to show if the statement is false? Meaning, what do you want to happen if your cell isn't yes or blank?

Report •

#2
February 4, 2015 at 07:29:58
Hi! I need it to stay blank, so null, please

Report •

#3
February 4, 2015 at 09:21:29
✔ Best Answer
In cell A3 enter the formula:

=IF(A2="Yes",EDATE(A1,3),"")

To check and make sure A1 is not blank, try this:

=IF(AND(A1<>"",A2="YES"),EDATE(A1,3),"")

Make sure that A3 is Formatted as a Date Cell.

See how it works for you.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question