| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with IF statement needed
Hi PAul,
=IF(P79="Pass",N79+(L79*2)+600),0) HTH Carim |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement - Help Needed | Excel Discussion (Misc queries) | |||
| IF statement w/ more than 7 arguments needed | Excel Worksheet Functions | |||
| If Then statement help needed | Excel Worksheet Functions | |||
| If statement help needed | Excel Worksheet Functions | |||
| If statement needed | Excel Worksheet Functions | |||
Linear Mode
