SOLVED

Functions

Copper 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 (Copper Contributor)
Solution

@ddufo10 

 

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.

 

Nikolino

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 :)

1 best response

Accepted Solutions
best response confirmed by ddufo10 (Copper Contributor)
Solution

@ddufo10 

 

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.

 

Nikolino

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.

View solution in original post