Remember Me?

#1
March 31st 05, 07:13 PM
 barb in NC Posts: n/a
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:

This worked on the true contdion, but the false condition is not returning

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

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
appreciate any suggestions.

THANKS!

#2
March 31st 05, 07:25 PM
 N Harkawat Posts: n/a

"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
my best try is below:

This worked on the true contdion, but the false condition is not returning

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
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
appreciate any suggestions.

THANKS!

#3
March 31st 05, 08:01 PM
 barb in NC Posts: n/a

thank you, thank you, thank you, thank you, THANK YOU! Worked like a charm.

"N Harkawat" wrote:

"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
my best try is below:

This worked on the true contdion, but the false condition is not returning

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
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
appreciate any suggestions.

THANKS!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Kim Excel Discussion (Misc queries) 2 March 15th 05 08:04 PM abs2299 Excel Discussion (Misc queries) 8 March 3rd 05 02:21 AM JUSTIN Excel Worksheet Functions 1 January 3rd 05 11:08 PM mark_kramarczyk Excel Worksheet Functions 1 December 29th 04 08:55 PM William Excel Worksheet Functions 2 November 17th 04 04:19 PM

All times are GMT +1. The time now is 03:35 AM.