Is there a way to get a cell to show alternate text based off deliberate characters found in a cell?

Hello, Is there a formula that will either place "Discount" or "Received" in a cell if another cell contains the characters "%" or "-" in it respectively. I have enclosed a image to better demon...

excel

Formulas and Functions

m_tarler
Oct 08, 2024
try
=IFS(ISNUMBER(SEARCH("%",A1)),"Discount",ISNUMBER(SEARCH("-",A1)),"Received",1,"")
if you have an older version of excel and IFS() doesn't work then:
=IF(ISNUMBER(SEARCH("%",A1)),"Discount",IF(ISNUMBER(SEARCH("-",A1)),"Received",""))

m_tarler

Bronze Contributor

Oct 08, 2024

try
=IFS(ISNUMBER(SEARCH("%",A1)),"Discount",ISNUMBER(SEARCH("-",A1)),"Received",1,"")
if you have an older version of excel and IFS() doesn't work then:
=IF(ISNUMBER(SEARCH("%",A1)),"Discount",IF(ISNUMBER(SEARCH("-",A1)),"Received",""))

itsMonty

Brass Contributor

Oct 08, 2024

Thank you this worked perfectly! I don't know how you all know which formulas to use, but I am so very grateful that you do and for the help. Cheers

Forum Discussion

Is there a way to get a cell to show alternate text based off deliberate characters found in a cell?

Resources