If Function - two conditions?
 

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!

If Function - two conditions?
 

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!