Searching a cell and setting another cell
Closed
stacks
-
Apr 23, 2010 at 09:09 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 23, 2010 at 12:48 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 23, 2010 at 12:48 PM
Related:
- Searching a cell and setting another cell
- Safe search setting - Guide
- Whatsapp time setting - Guide
- Google searching in another country - Guide
- An example of a cell is a blank cell ✓ - Programming Forum
- Lg tv setting subtitles - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 23, 2010 at 12:48 PM
Apr 23, 2010 at 12:48 PM
Use IF statements
=IF(A2="roadmap","roadmap",IF(OR(A2="startup",A2="feasibility",A2="definition"),"Planning",IF(OR(A2="Build",A2="deploy"),"Building","none of the choice")))
=IF(A2="roadmap","roadmap",IF(OR(A2="startup",A2="feasibility",A2="definition"),"Planning",IF(OR(A2="Build",A2="deploy"),"Building","none of the choice")))