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 reply

vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252
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.
0
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