Conditional text based on text in another cell

Closed
Benjaim Posts 1 Registration date Saturday July 25, 2015 Status Member Last seen July 25, 2015 - Jul 25, 2015 at 07:38 AM
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 - Jul 26, 2015 at 05:27 AM
Hi,
I'm trying to format a cell (D2) on Excel 2007 so that when the cell next to it (E2) contains "LFC-0.3", it will say "Downregulated", but if the cell says "LFC+0.3", it will say "Upregulated".
Hope you can help!
Benjaim

1 response

vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262
Jul 25, 2015 at 09:06 AM
Hello Benjaim,

The following formula should do the task for you:-

=IF(E2="LFC-0.3","Downregulated",IF(E2="LFC+0.3","Upregulated",""))


Place it in cell D2.

I hope that this helps.

Cheerio,
vcoolio.
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 1
Jul 26, 2015 at 05:27 AM
I think this formula will work too for u
=IF(E2="LFC-0.3","Downregulated","Upregulated")
0