Help with IF statement needed
Disregard my reply, one of my cells had been changed to text when it should
have been number.
It works fine now.
Cheers
"Paul B." wrote:
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.
|