Inputting a text based on another column Text.
Closed
Rigby
-
Oct 18, 2015 at 10:32 AM
bimmy80 Posts 9 Registration date Saturday October 17, 2015 Status Member Last seen November 19, 2015 - Oct 21, 2015 at 03:04 AM
bimmy80 Posts 9 Registration date Saturday October 17, 2015 Status Member Last seen November 19, 2015 - Oct 21, 2015 at 03:04 AM
Related:
- Auto serial number in excel based on another column
- Number to words in excel - Guide
- Grand theft auto 1 download - Download - Action and adventure
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Facebook auto refresh - Guide
- Nvidia drivers auto detect - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 20, 2015 at 02:22 PM
Oct 20, 2015 at 02:22 PM
in B1 have, a formula like
=IF(F1="PENDING", "PENDING", "here is the else part")
or
=F1 to show what ever is in F1
=IF(F1="PENDING", "PENDING", "here is the else part")
or
=F1 to show what ever is in F1
bimmy80
Posts
9
Registration date
Saturday October 17, 2015
Status
Member
Last seen
November 19, 2015
Oct 21, 2015 at 03:04 AM
Oct 21, 2015 at 03:04 AM
Hi Rigby,
Let me explain rizvisa1's formula
If B1 has the word Pending then using below formula will reflect the word Pending in B1
=IF(F1="Pending", "Pending", "")
If B1 does not contain the word Pending or if there is any spelling mistake in the word Pending then using below formula will reflect the word Incorrect
=IF(F1="Pending", "Pending", "Incorrect")
You can use any other word or sentence to highlight that the info in B1 is incorrect but use inverted commas
Hope this helps
Let me explain rizvisa1's formula
If B1 has the word Pending then using below formula will reflect the word Pending in B1
=IF(F1="Pending", "Pending", "")
If B1 does not contain the word Pending or if there is any spelling mistake in the word Pending then using below formula will reflect the word Incorrect
=IF(F1="Pending", "Pending", "Incorrect")
You can use any other word or sentence to highlight that the info in B1 is incorrect but use inverted commas
Hope this helps
Oct 20, 2015 at 04:59 PM
I turely appreciate your help and taking the time to assist me. I am a little confused. I understand =IF(F1="PENDING", "PENDING", but do not understand what is meant by "here is the else part"). Is there something I should place in the else part? Or where should I place =F1 when managing the rule for the B cell.
Thanks again for taking the time to help.