Comparing 2 Columns and returning an answer
Closed
Lenny
-
20 Aug 2010 à 19:34
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 24 Aug 2010 à 08:01
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 24 Aug 2010 à 08:01
Related:
- Comparing 2 Columns and returning an answer
- Tentacle locker 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- How to answer call with volume button android - Guide
- Fnia 2 - Download - Adult games
- Feeding frenzy 2 download - Download - Arcade
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
24 Aug 2010 à 08:01
24 Aug 2010 à 08:01
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)
