Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Function with multiple criteria
Hi, I have am trying to use the If function to deliver a value if 2 criteria
are true for 2 different fields. Both contains dates. The first field is blank or not. The 2nd field is filled in. The criteria I am trying to find is if the 1st field is blank and the 2nd field is earlier than today, the function should deliver the value "Overdue" to the third field. How can I use the If function to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Function with multiple criteria
HI
Look at this: =IF(A2="",IF(B2<C1,"Overdue",""),"") Regards, Per "GPearson" skrev i meddelelsen ... Hi, I have am trying to use the If function to deliver a value if 2 criteria are true for 2 different fields. Both contains dates. The first field is blank or not. The 2nd field is filled in. The criteria I am trying to find is if the 1st field is blank and the 2nd field is earlier than today, the function should deliver the value "Overdue" to the third field. How can I use the If function to do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Function with multiple criteria
check out the Boolean functions AND & OR
=IF(AND(ISBLANK(Cell1),Cell2<TODAY()),"Overdue","C riteria not met") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "GPearson" wrote: Hi, I have am trying to use the If function to deliver a value if 2 criteria are true for 2 different fields. Both contains dates. The first field is blank or not. The 2nd field is filled in. The criteria I am trying to find is if the 1st field is blank and the 2nd field is earlier than today, the function should deliver the value "Overdue" to the third field. How can I use the If function to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if function with multiple criteria | Excel Worksheet Functions | |||
IF Function with Multiple Criteria | Excel Worksheet Functions | |||
Multiple results from multiple criteria using IF function | Excel Discussion (Misc queries) | |||
Multiple Sheet, Multiple Criteria Look-Up Function Help | Excel Worksheet Functions | |||
Look up function for multiple criteria | Excel Worksheet Functions |