Forum Discussion
Using IF function to create scores
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 th...
Values enclosed in quotes, such as "5", are text. Since you want to sum the values, omit the quotes:
=IF(F25="C", 5, 0)