If Cell1 < Cell2 then add 1 month or if Cell1 = blank then blank

**robertmiller** · 06-27-2012, 10:36 AM

Having some trouble with a formula.

The formula is below:

=IF(C10<E9,DATE(YEAR(D9),MONTH(D9)+1,DAY(D9)),IF(AND(E9<=$H$9,E9>$H$7),DATE(YEAR(D9),MONTH(D9)+1,DAY(D9)),"Unable To Roll"))

I also want to incorporate the logic, if C10="","". I just can't seem to figure this out.

**NBVC** · 06-27-2012, 10:38 AM

Do you mean?

Please Login or Register  to view this content.

which can probably be rewritten as:

Please Login or Register  to view this content.

**robertmiller** · 06-27-2012, 10:42 AM

Worked perfectly. Thanks for the help!!

**robertmiller** · 06-27-2012, 02:56 PM

I was mistaken. It will no longer recognize IF(OR(C10<E9,AND(E9<=$H$9,E9>$H$7)),DATE(YEAR(D9),MONTH(D9)+1,DAY(D9)),"Unable To Roll")). Regardless of what I input into Cell C10, it will continue to add 1 month.

To break it down, I need the formula to do quite a few things:

1.) If C10 is blank, give me a blank value in return
2.) If C10 is less than E9 then add 1 month
3.) If E9 is <= H9 and E9 is > H7 then add 1 month

**NBVC** · 06-27-2012, 03:08 PM

The formula works fine for me.

Do you have Automatic calculations off by any chance?

Go to Tools|Options and in Calculation tab, check Automatic calculations on.

**robertmiller** · 06-27-2012, 03:19 PM

I think it may be the way I'm explaining it then. I'm attaching the file to see if it helps. It will work if E9 > H7, however if H7 is blank and C10 is > E9, it will still add a month to the calculation.