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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 25, 2010 at 08:21 AM
Related:
- If function extended
- Idle master extended - Download - Gaming tools
- Extended best friends list snapchat - Guide
- Find function on mac - Guide
- Age of mythology extended edition free download - Download - Strategy
- Accessor function c++ - Guide
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
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)
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)