If A1 is Ultra 2GB then 800
Closed
Faisal
-
Feb 20, 2010 at 03:44 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 20, 2010 at 04:06 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 20, 2010 at 04:06 PM
Related:
- If A1 is Ultra 2GB then 800
- Gta 5 download pc 2gb ram - Download - Action and adventure
- Ultra ball cheat code fire red - Guide
- Ultra surf - Download - VPN
- Which formula am i going to use if i want to know if the text "bacon" appears in the content of cell a1 ? ✓ - Word Forum
- My cloud ex2 ultra red light - Hard Drive & SSD Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 20, 2010 at 04:06 PM
Feb 20, 2010 at 04:06 PM
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
