If function extended

Closed
PM - Mar 25, 2010 at 06:39 AM
rizvisa1 Posts 4478 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
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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