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, 21 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?

__________________
Using O365 v2503 - 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.