New Contributor

I am trying to use the If function and i cannot get it to result what I need. I have cell c2 as a pick list of yes, no, unknown. D cell i would like to result $10,000 if c cell is yes. no other results are necessary.


my fuction looks like so,  IF(c2=yes,10000)  and it results in #NAME?


if i change the formula to IF(c2=1,10000) it works. 

3 Replies
best response confirmed by ddufo10 (New Contributor)



Here is a suggested solution in the inserted file.


This formula was used:

=IF(C2="Yes","$ F10.000","")


I would be happy to know if I could help.



I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

That worked perfectly, not sure what I was doing differently. I was able to remove the F and format the cells as currency afterward. this was great and quick thank you!

yw & thx