I want to use the IF function to return a value in excel.

Example
A1 is equal to X than return Sales in the cell.



I tried a number if functions but could not get it to work.

Attached Files

Book1.xlsx (7.6 KB, 19 views)

Add quotation marks before and after the X, like
=if(A2="X","Sales",0)

Marcia, were you able to download the OP's attachment?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you. it worked.