SOLVED

Functions

%3CLINGO-SUB%20id%3D%22lingo-sub-2587585%22%20slang%3D%22en-US%22%3EFunctions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2587585%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20use%20the%20If%20function%20and%20i%20cannot%20get%20it%20to%20result%20what%20I%20need.%20I%20have%20cell%20c2%20as%20a%20pick%20list%20of%20yes%2C%20no%2C%20unknown.%20D%20cell%20i%20would%20like%20to%20result%20%2410%2C000%20if%20c%20cell%20is%20yes.%20no%20other%20results%20are%20necessary.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emy%20fuction%20looks%20like%20so%2C%26nbsp%3B%20IF(c2%3Dyes%2C10000)%26nbsp%3B%20and%20it%20results%20in%20%23NAME%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20i%20change%20the%20formula%20to%20IF(c2%3D1%2C10000)%20it%20works.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2587585%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2587642%22%20slang%3D%22de-DE%22%3ESubject%3A%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2587642%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1112876%22%20target%3D%22_blank%22%3E%40ddufo10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20is%20a%20suggested%20solution%20in%20the%20inserted%20file.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThis%20formula%20was%20used%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%3DIF(C2%3D%22Yes%22%2C%22%24%20F10%2C000%22%2C%22%22)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2587661%22%20slang%3D%22en-US%22%3EBetreff%3A%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2587661%22%20slang%3D%22en-US%22%3EThat%20worked%20perfectly%2C%20not%20sure%20what%20I%20was%20doing%20differently.%20I%20was%20able%20to%20remove%20the%20F%20and%20format%20the%20cells%20as%20currency%20afterward.%20this%20was%20great%20and%20quick%20thank%20you!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
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)
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