healimonster
04-22-2010, 01:13 AM
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
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