| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3 logical condition if statement
Hi, I.m sure this is simple if you know how but i'm confused. I have a cell that I want to return 1 of 3 values, these being "Ongoing" "Complete" or lastly "Overdue" Condition 1 Ongoing is returned if the date in A1 is less than the date in A2 Condition 2 Complete is returned if there is an "x" in A3 irrespective of the date. Condition 3 Overdue is returned if there is no "x" in A3 and the datein A1 is greater than the date in A2 Thanks for any help you can offer -- Mikehughes ------------------------------------------------------------------------ Mikehughes's Profile: http://www.excelforum.com/member.php...o&userid=36528 View this thread: http://www.excelforum.com/showthread...hreadid=562805 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
3 logical condition if statement
Try
=if(A3="x","Complete",if(A1<A2,"Ongoing",if(A1A2, "Overdue",""))) "Mikehughes" wrote: Hi, I.m sure this is simple if you know how but i'm confused. I have a cell that I want to return 1 of 3 values, these being "Ongoing" "Complete" or lastly "Overdue" Condition 1 Ongoing is returned if the date in A1 is less than the date in A2 Condition 2 Complete is returned if there is an "x" in A3 irrespective of the date. Condition 3 Overdue is returned if there is no "x" in A3 and the datein A1 is greater than the date in A2 Thanks for any help you can offer -- Mikehughes ------------------------------------------------------------------------ Mikehughes's Profile: http://www.excelforum.com/member.php...o&userid=36528 View this thread: http://www.excelforum.com/showthread...hreadid=562805 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
3 logical condition if statement
Here's one that will also check for TEXT values in A1 and A2......
=IF(OR(ISTEXT(A1),ISTEXT(A2)),"Improper value",IF(A3="x","Complete",IF(A1<A2,"Ongoing",IF( A1A2,"Overdue","")))) Vaya con Dios, Chuck, CABGx3 "Mikehughes" wrote: Hi, I.m sure this is simple if you know how but i'm confused. I have a cell that I want to return 1 of 3 values, these being "Ongoing" "Complete" or lastly "Overdue" Condition 1 Ongoing is returned if the date in A1 is less than the date in A2 Condition 2 Complete is returned if there is an "x" in A3 irrespective of the date. Condition 3 Overdue is returned if there is no "x" in A3 and the datein A1 is greater than the date in A2 Thanks for any help you can offer -- Mikehughes ------------------------------------------------------------------------ Mikehughes's Profile: http://www.excelforum.com/member.php...o&userid=36528 View this thread: http://www.excelforum.com/showthread...hreadid=562805 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
3 logical condition if statement
I knew it was simple!!! Thanks a lot for helping me out Mike -- Mikehughes ------------------------------------------------------------------------ Mikehughes's Profile: http://www.excelforum.com/member.php...o&userid=36528 View this thread: http://www.excelforum.com/showthread...hreadid=562805 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a logical IF statement with TEXT in EXCEL | Excel Worksheet Functions | |||
| Blanks as a condition of a statement | New Users to Excel | |||
| Condition Statement | Excel Discussion (Misc queries) | |||
| If statement where the logical test is a range that equals a word | Excel Worksheet Functions | |||
| Want to change the color of a true/false logical statement with i. | Excel Worksheet Functions | |||
Linear Mode
