If A1 is Ultra 2GB then 800
Closed
Faisal
-
20 Feb 2010 à 15:44
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Feb 2010 à 16:06
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Feb 2010 à 16:06
Related:
- If A1 is Ultra 2GB then 800
- Ultra custom night apk - Download - Horror
- Pokemon fire red ultra ball - Guide
- Ultra iso - Download - CD and DVD
- Transcend jf v30 2gb ✓ - Phones, PDA & GPS Forum
- My cloud ex2 ultra red light - Hard Drive & SSD Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
20 Feb 2010 à 16:06
20 Feb 2010 à 16:06
Use if statement
like
=If( condition, do this for true, do this for false)
=IF(A1="Ultra 2GB", 800, IF(A1="Ultra 5GB", 3500, IF(A1="ZOOM 2GB", 400, "none of the three")))
You get the idea. Side note you can have upto 7 nested if. If more than that is needed, you need to look at some other way
like
=If( condition, do this for true, do this for false)
=IF(A1="Ultra 2GB", 800, IF(A1="Ultra 5GB", 3500, IF(A1="ZOOM 2GB", 400, "none of the three")))
You get the idea. Side note you can have upto 7 nested if. If more than that is needed, you need to look at some other way
