Home 
Search 
Today's Posts 
#1




How to calculate a sum as one outcome of an IF statement
I am working on a grade book. The teacher gives 12 quizzes worth 10 points
each, but the maximum credit allowed for quizzes is 100 points, not the mathematically possible 120 points. I think an IF statement is the answer, my best try is below: IF(=100, "100", "=L8+O8+R8+U8+X8+AA8+AD8+AG8+AJ8+AM8+AP8+AS8") This worked on the true contdion, but the false condition is not returning the sum, but rather =L8+O8+R8+U8+X8+AA8+AD8+AG8+AJ8+AM8+AP8+AS8. I have tried all the variations I can think of to tell it to return the sum in the false condition (the sum is less than 100), but I can't find the right grammar. Removing the quotation marks made the statement invalid, as did surrounding the L8+O8+R8+U8+X8+AA8+AD8+AG8+AJ8+AM8+AP8+AS8 with parentheses. I tried to approach it with a SUMIF statement, but didn't see that as an answer, though I admit I was running out of enthusiasm by then. I've tried the online help, and as ever, not found the issue addressed. I'd sure appreciate any suggestions. THANKS! 
#2




How about simply
=min(100,(L8+O8+R8+U8+X8+AA8+AD8+AG8+AJ8+AM8+AP8+A S8)) "barb in NC" wrote in message ... I am working on a grade book. The teacher gives 12 quizzes worth 10 points each, but the maximum credit allowed for quizzes is 100 points, not the mathematically possible 120 points. I think an IF statement is the answer, my best try is below: IF(=100, "100", "=L8+O8+R8+U8+X8+AA8+AD8+AG8+AJ8+AM8+AP8+AS8") This worked on the true contdion, but the false condition is not returning the sum, but rather =L8+O8+R8+U8+X8+AA8+AD8+AG8+AJ8+AM8+AP8+AS8. I have tried all the variations I can think of to tell it to return the sum in the false condition (the sum is less than 100), but I can't find the right grammar. Removing the quotation marks made the statement invalid, as did surrounding the L8+O8+R8+U8+X8+AA8+AD8+AG8+AJ8+AM8+AP8+AS8 with parentheses. I tried to approach it with a SUMIF statement, but didn't see that as an answer, though I admit I was running out of enthusiasm by then. I've tried the online help, and as ever, not found the issue addressed. I'd sure appreciate any suggestions. THANKS! 
#3




thank you, thank you, thank you, thank you, THANK YOU! Worked like a charm.
"N Harkawat" wrote: How about simply =min(100,(L8+O8+R8+U8+X8+AA8+AD8+AG8+AJ8+AM8+AP8+A S8)) "barb in NC" wrote in message ... I am working on a grade book. The teacher gives 12 quizzes worth 10 points each, but the maximum credit allowed for quizzes is 100 points, not the mathematically possible 120 points. I think an IF statement is the answer, my best try is below: IF(=100, "100", "=L8+O8+R8+U8+X8+AA8+AD8+AG8+AJ8+AM8+AP8+AS8") This worked on the true contdion, but the false condition is not returning the sum, but rather =L8+O8+R8+U8+X8+AA8+AD8+AG8+AJ8+AM8+AP8+AS8. I have tried all the variations I can think of to tell it to return the sum in the false condition (the sum is less than 100), but I can't find the right grammar. Removing the quotation marks made the statement invalid, as did surrounding the L8+O8+R8+U8+X8+AA8+AD8+AG8+AJ8+AM8+AP8+AS8 with parentheses. I tried to approach it with a SUMIF statement, but didn't see that as an answer, though I admit I was running out of enthusiasm by then. I've tried the online help, and as ever, not found the issue addressed. I'd sure appreciate any suggestions. THANKS! 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How can I calculate Vacation Time earned based on length of emplo.  Excel Discussion (Misc queries)  
formula to calculate # of days between dates, excluding holidays  Excel Discussion (Misc queries)  
X IN A CELL TO CALCULATE A FORMULA  Excel Worksheet Functions  
Not able to calculate.  Excel Worksheet Functions  
How do you calculate the nth root of a number in Excel 2003?  Excel Worksheet Functions 