Help with IF statement needed
I cannot figure out why I don't get a value with the following:
=IF(P79="Pass", SUM((N79),(L79*2),600),0)
I need to check that P79 = "Pass", then I need to add the values from N79,
L79*2 and 600 for a total score, or 0 if P79 does not equal Pass.
Any help would be appreciated.
|