Comparing 2 Columns and returning an answer
Closed
Lenny
-
Aug 20, 2010 at 07:34 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 24, 2010 at 08:01 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 24, 2010 at 08:01 AM
Related:
- Comparing 2 Columns and returning an answer
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Plants vs zombies 2 pc download - Download - Strategy
- Red dead redemption 2 free download - Download - Action and adventure
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 24, 2010 at 08:01 AM
Aug 24, 2010 at 08:01 AM
looks like you are looking for IF statement
=IF(D1="X", B1, "")
this says if D1 is x, then show me B1 value. If d1 is not x, then show me ""
You can have upto 7 nested if and you can use AND /OR with IF
example
=IF(AND(cond1, cond2), true, false)
=IF(AND(cond1, cond2), if(cond, true, false), false)
=IF(D1="X", B1, "")
this says if D1 is x, then show me B1 value. If d1 is not x, then show me ""
You can have upto 7 nested if and you can use AND /OR with IF
example
=IF(AND(cond1, cond2), true, false)
=IF(AND(cond1, cond2), if(cond, true, false), false)