Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is it possble to make two conditions (logical test) in the IF statement.
For example IF A1 = ("Rejected" or "Denied",A2+90,A2+30) I tried this but it was not accepted - invalid. What is the correct way to do this? Thanks! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this:
=IF(OR(A1={"Rejected","Denied"}),A2+90,A2+30) Biff "TypeType" wrote in message ... Is it possble to make two conditions (logical test) in the IF statement. For example IF A1 = ("Rejected" or "Denied",A2+90,A2+30) I tried this but it was not accepted - invalid. What is the correct way to do this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use IF function for two conditions | Excel Worksheet Functions | |||
If function with more than 7 conditions | Excel Worksheet Functions | |||
Multiple Conditions within an IF Function | Excel Worksheet Functions | |||
SUMIF function with 2 conditions | Excel Worksheet Functions | |||
Two Conditions Function | Excel Worksheet Functions |