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
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 - Jul 26, 2015 at 05:27 AM
Related:
- Conditional text based on text in another cell
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- How to change account based in instagram - Instagram Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- Count if cell contains number - Excel Forum
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Jul 25, 2015 at 09:06 AM
Jul 25, 2015 at 09:06 AM
Hello Benjaim,
The following formula should do the task for you:-
Place it in cell D2.
I hope that this helps.
Cheerio,
vcoolio.
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.
Jul 26, 2015 at 05:27 AM
=IF(E2="LFC-0.3","Downregulated","Upregulated")