Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple formats in a single cell with multiple formulas | Excel Worksheet Functions | |||
multiple formulas in an IF | Excel Worksheet Functions | |||
Multiple-Value formulas | Excel Worksheet Functions | |||
Sort multiple columns with multiple formulas without returning #R | Excel Worksheet Functions | |||
Multiple Formulas | Excel Discussion (Misc queries) |