Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Formula to Find&replace blank cells in excel
onetuff_z -
tstobb -

11 responses