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 demonstrate below. The idea is if I place 12% in col. A it will find the percentage character then in col. C will show “Discount” but if it is a date with a dash then it shows “Received”. If it finds neither I’d like it to be blank. The cells in column A are formatted as TEXT.

Any assistance will be greatly appreciated. 

​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 demonstrate below. The idea is if I place 12% in col. A it will find the percentage character then in col. C will show “Discount” but if it is a date with a dash then it shows “Received”. If it finds neither I’d like it to be blank. The cells in column A are formatted as TEXT.Any assistance will be greatly appreciated.    Read More

​