simple excel question for the excel wizards

[healimonster]

The people on this forum back in the day could help answer nearly any computer related question. I hope this remains true to this day. it is good to be back here by the way.

A have a simple excel formula problem question.

I am trying to have a cell show 1 point if the sum of a number of cells =5 and 4 points if that sum of cells is 10.

I was able to create a simple "if" formula that was able to do the first half of my formula problem

=IF(SUM(C5:C7)>4,1,0)

That formula will display a certain cell with a 0(points) total until the sum of the cells in question reaches 5 and then it will display a number 1(point). What i cant figure out is how to add onto this formula to get it to display 4 (points) when the cells in question reach 10.

Does that make sense?

Should I be using the IF formula if there is more than one true or false answer?

Thanks for any suggestions
Heali

[vivitron 15]

have you tried

=IF(SUM(C5:C7)>9,4,IF(SUM(C5:C7)>4,1,0))
?

I think that should do it. It's a little clunky, and wouldn't reccomend it for anything longer than two, but it'll do the trick.

[healimonster]

Bingo!
Worked like a charm.
Thank you kind sir... mr 15inch Vivitron.

[vivitron 15]

glad to have helped!