If function extended

Closed
PM - Mar 25, 2010 at 06:39 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Mar 25, 2010 at 08:21 AM
Hi,

I want to know how to do the following if function with extra conditions:


If cell D1= 0 or 2 then do the following......

I can make the if function work with 1 condition.

Excel 2003

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Mar 25, 2010 at 08:21 AM
You can have up to 7 nested if

LIKE THIS
=IF(COND, IF(COND2, true, false), IF(COND3,true, IF(COND5, true, FALSE)))

also you can use of AND and OR

=IF(AND(a1=b1, d1>today()), true, false)

for you example you can have some thing like

=IF(OR(D1=0, D1=2), true, false)
0