Jul 26 2021 09:21 AM
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.
Jul 26 2021 09:32 AM
Solution
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.
Jul 26 2021 09:37 AM
Jul 26 2021 09:32 AM
Solution
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.