Excell find in a cell some text

Closed
mcarcanague
Posts
1
Registration date
Friday September 7, 2012
Status
Member
Last seen
September 7, 2012
- Sep 7, 2012 at 12:30 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Sep 10, 2012 at 09:45 AM
Hello,
I am trying to find in a cell some text. I would want for example in D1 to see if it had: Low Low, if so put a 1 in the E1; High High, put a 1 in E1; MFT, put a 1 in E1, Purge, put a 3 into E1, E-stop, put a 2 into E1; Low put a 2 into E1; High, put a 2 into E1.

Any help? Please.


1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Sep 10, 2012 at 09:45 AM
you can use an if statement for that
in E1 you can have
=IF(D1="LOW LOW", 1,"")
0