View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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.