Using IF function to create scores

%3CLINGO-SUB%20id%3D%22lingo-sub-2139060%22%20slang%3D%22en-US%22%3EUsing%20IF%20function%20to%20create%20scores%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2139060%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20using%20the%20IF%20function%20to%20create%20a%20score.%3C%2FP%3E%3CP%3EE.G%26nbsp%3B%3DIF(F25%3D%20%22C%22%2C%225%22%2C%20%220%22)%20This%20creates%20a%20score%20of%205.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20put%20the%20various%20formulas%20and%20scores%20into%20the%20appropriate%20cells%2C%20however%20when%20i%20use%20the%20sum%20function%20to%20add%20up%20the%20scores%20i%20get%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20i%20add%20the%20scores%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2139060%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, I am using the IF function to create a score.

E.G =IF(F25= "C","5", "0") This creates a score of 5. 

I have put the various formulas and scores into the appropriate cells, however when i use the sum function to add up the scores i get 0.

 

How can i add the scores?

1 Reply

@dwherron 

Values enclosed in quotes, such as "5", are text. Since you want to sum the values, omit the quotes:

 

=IF(F25="C", 5, 0)