Conditional text based on text in another cell

[Closed]
Report
Posts
1
Registration date
Saturday July 25, 2015
Status
Member
Last seen
July 25, 2015
-
Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
-
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

Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
239
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.
Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
1
I think this formula will work too for u
=IF(E2="LFC-0.3","Downregulated","Upregulated")