| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assistance for the IF Function
I'm trying to test the condition of Cell A1 for either/or and B1 for
either/or and if C1 is true, display the value of D1 =(IF(OR(A1="SHIP",A1="Postal"),+IF(OR(B1="Debit",B 1="Payment"),"","",+IF(AND(C1="completed"),D1,"")* ),"")) I'm stuck! How should this be? Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assistance for the IF Function
Maybe this:
=IF(AND(OR(A1={"Ship","Postal"}),OR(B1={"Debit","P ayment"}),C1="Completed"),D1,"") -- Biff Microsoft Excel MVP "Kentucky Hot Brown" <Kentucky Hot wrote in message ... I'm trying to test the condition of Cell A1 for either/or and B1 for either/or and if C1 is true, display the value of D1 =(IF(OR(A1="SHIP",A1="Postal"),+IF(OR(B1="Debit",B 1="Payment"),"","",+IF(AND(C1="completed"),D1,"")* ),"")) I'm stuck! How should this be? Thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assistance for the IF Function
Biff.... thanks... You did it!
Ted "T. Valko" wrote: Maybe this: =IF(AND(OR(A1={"Ship","Postal"}),OR(B1={"Debit","P ayment"}),C1="Completed"),D1,"") -- Biff Microsoft Excel MVP "Kentucky Hot Brown" <Kentucky Hot wrote in message ... I'm trying to test the condition of Cell A1 for either/or and B1 for either/or and if C1 is true, display the value of D1 =(IF(OR(A1="SHIP",A1="Postal"),+IF(OR(B1="Debit",B 1="Payment"),"","",+IF(AND(C1="completed"),D1,"")* ),"")) I'm stuck! How should this be? Thanks in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assistance for the IF Function
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Kentucky Hot Brown" wrote in message ... Biff.... thanks... You did it! Ted "T. Valko" wrote: Maybe this: =IF(AND(OR(A1={"Ship","Postal"}),OR(B1={"Debit","P ayment"}),C1="Completed"),D1,"") -- Biff Microsoft Excel MVP "Kentucky Hot Brown" <Kentucky Hot wrote in message ... I'm trying to test the condition of Cell A1 for either/or and B1 for either/or and if C1 is true, display the value of D1 =(IF(OR(A1="SHIP",A1="Postal"),+IF(OR(B1="Debit",B 1="Payment"),"","",+IF(AND(C1="completed"),D1,"")* ),"")) I'm stuck! How should this be? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function assistance | Excel Worksheet Functions | |||
| Need assistance with IF function when calculating dates | Excel Worksheet Functions | |||
| If Function Assistance | Excel Worksheet Functions | |||
| 1-2-3 @ function to Excel Assistance | Excel Worksheet Functions | |||
| Average function assistance | Excel Discussion (Misc queries) | |||
Linear Mode
