multiple IF formulas

  • Thread starter Thread starter JayDee
  • Start date Start date
J

JayDee

In A1, I have a date linked from another file worksheet. I used the If (is
blank) formula so no data appears unless there is a date to link from the
other worksheet.

In A2, I also have a date linked from another file worksheet. I also used
the If (is blank) formula so no data appears unless there is a date to link
from the other file worksheet.

I am trying to write a formula for Cell A3 that will return a given phrase
(i.e. past due) if the date in cell A2 is greater than the date A1. AND,
return a blank cell for A3 if there are no dates in cells A1 or A2.
 
=IF(ISBLANK(A1&A2),"",IF(A2>A1,"Past Due",""))
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown
 
Nice of you to notice, of course, you didn't notice that cells A1 and A2 are
pulling in dates from another sheet, and therefore, other values do not
populate in cells A1 & A2.
 
Understood Mama.
This is because there can NEVER be a Past due date if a DUE BY date is
unknown. This signifies a data entry error.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown
 
touche !

--
Biff
Microsoft Excel MVP


John C said:
Nice of you to notice, of course, you didn't notice that cells A1 and A2
are
pulling in dates from another sheet, and therefore, other values do not
populate in cells A1 & A2.
Click to expand...
 
Back
Top