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.

Help with IF statement needed
 

Try this:

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

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

XL2002, WinXP


"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.

Help with IF statement needed
 

Hi PAul,

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

HTH
Carim

Help with IF statement needed
 

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.



"Ron Coderre" wrote:

Try this:

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

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

XL2002, WinXP


"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.

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.

Help with IF statement needed
 

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

--
Regards,
Dave


"Paul B." wrote:

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.



"Ron Coderre" wrote:

Try this:

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

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

XL2002, WinXP


"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.