Having trouble with nested if commands

**pmilligan1979** · 09-11-2012, 11:43 AM

B321= the cell above which has a date
E13 is the cell with the end date
If the date in B321 plus 1 month is greater than thedate in E13 I want a "-" in the field.
For the next cell down that makes an error
So I also want to put that if ther cell above = "-" then put a "-" in that cell.
The first cell down where it is greater than the date in E13 works, the cells below all give me #VALUE!
It seems to not work becasue the if fales creates a #VALUE!, but why would that matter when it should not even be looking at the if false?

I have been trying this for hours and it is frustrating!!

=IF(OR(B321="-",ISERROR(DATE(YEAR(B321),MONTH(B321)+1,DAY(B321)))>$E$13),"-",DATE(YEAR(B321),MONTH(B321)+1,DAY(B321)))

Thanks for the help!

Patrick

**NBVC** · 09-11-2012, 11:49 AM

Why doesn't this work?

=IF(OR(B321="-",DATE(YEAR(B321),MONTH(B321)+1,DAY(B321))>$E$13),"-",DATE(YEAR(B321),MONTH(B321)+1,DAY(B321)))

**pmilligan1979** · 09-11-2012, 12:28 PM

The DATE(YEAR(B321),MONTH(B321)+1,DAY(B321))>$E$13 creates a #VALUE! and for some reason it is ignoring the IF(OR(B321="-" and I think it is because of the error. It seems like it should work to me too, I have tried the iferror command as well and it does not help either.

E13 Oct 5, 2037

B320 Oct 5, 2037
B321 -
B322 #VALUE!

That is what I keep getting

Pat

**NBVC** · 09-11-2012, 02:12 PM

How about?

=IF(ISERROR(DATE(YEAR(B321),MONTH(B321)+1,DAY(B321))),"-",IF(OR(B321="-",DATE(YEAR(B321),MONTH(B321)+1,DAY(B321))>$E$13),"-",DATE(YEAR(B321),MONTH(B321)+1,DAY(B321))))