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 4478 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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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