G
Guest
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!
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!