Help with IF statement needed

[Guest]

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.

 

[Guest]

Try this:

=IF(P79="Pass", SUM((N79,L79*2,600),0)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Carim]

Hi PAul,

=IF(P79="Pass",N79+(L79*2)+600),0)

HTH
Carim

 

[Guest]

Thanks for the quick reply, but no, it doesn't make any diffence, the cell
only shows the formula, not the value. I checked the format of the cell to
make sure is was numerical, still no joy.

 

[Guest]

Disregard my reply, one of my cells had been changed to text when it should
have been number.

It works fine now.

Cheers

 

[Guest]

Hit Ctrl+` (the key directly to the left of the 1 key)
Does that help?