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!

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!

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!