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
- Based on the cell values in cells b77 - Excel Forum
- Instagram account based in wrong country - Instagram Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Based on the values in cells b77 ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
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")