| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple IF formulas
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple IF formulas
=IF(OR(A1="",A2=""),"",IF(A2A1,"PAST DUE",""))
Hope that helps. -- John C "JayDee" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple IF formulas
Your formula will fail if there are text value example: a1=a, a2=b
=IF(OR(A1="",A2=""),"",IF(A2A1,"PAST DUE","")) "John C" wrote: =IF(OR(A1="",A2=""),"",IF(A2A1,"PAST DUE","")) Hope that helps. -- John C "JayDee" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple IF formulas
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. -- John C "Teethless mama" wrote: Your formula will fail if there are text value example: a1=a, a2=b =IF(OR(A1="",A2=""),"",IF(A2A1,"PAST DUE","")) "John C" wrote: =IF(OR(A1="",A2=""),"",IF(A2A1,"PAST DUE","")) Hope that helps. -- John C "JayDee" wrote: 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple IF formulas
touche !
-- Biff Microsoft Excel MVP "John C" <johnc@stateofdenial wrote in message ... 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. -- John C "Teethless mama" wrote: Your formula will fail if there are text value example: a1=a, a2=b =IF(OR(A1="",A2=""),"",IF(A2A1,"PAST DUE","")) "John C" wrote: =IF(OR(A1="",A2=""),"",IF(A2A1,"PAST DUE","")) Hope that helps. -- John C "JayDee" wrote: 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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple IF formulas
=IF(ISBLANK(A1&A2),"",IF(A2A1,"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 "JayDee" wrote: 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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple IF formulas
Your formula fail. It returns past Due instead of blank. if A1=<blank,
A2=date value =IF(ISBLANK(A1&A2),"",IF(A2A1,"Past Due","")) "Gary Brown" wrote: =IF(ISBLANK(A1&A2),"",IF(A2A1,"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 "JayDee" wrote: 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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple IF formulas
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 "Teethless mama" wrote: Your formula fail. It returns past Due instead of blank. if A1=<blank, A2=date value =IF(ISBLANK(A1&A2),"",IF(A2A1,"Past Due","")) "Gary Brown" wrote: =IF(ISBLANK(A1&A2),"",IF(A2A1,"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 "JayDee" wrote: 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. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple IF formulas
Try this:
=IF(AND(COUNT(A1:A2)=2,A2A1),"past due","") "JayDee" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
