Trying to create scoring sheet in excel.?

Question

I'm trying to create a scoring sheet in MS excel and need some help.

I'm looking to have one column where I put a number in and then in the next column it will automatically determine the value that I have assigned for the number that was previously put in.

For example....if Jimmy does between 70-109 things correct he will get 1 point. 110-149 things and he gets 2 points, etc. Any help would be greatly appreciated.

Answer 1

You can make the forumla = x> or x<.  You can make a forumla select which grade by using this.  

For example, a1 would =a2*(points) if x >149 or <149. Hard to explain on here sorry.  

Answer 2

Guy above me is right.

Answer 3

Just create an IF statement...something like this (assume you are putting in the # of things done correctly in A1)

=IF(AND(A1>=70, A1<=109), 1, IF(AND(A1>=110, A1<=149), 2, 0))

and you could keep expanding this IF for higher ranges.  

the basic syntax of the if statement is

IF <something is true>, <do something>, <otherwise do something else>

and you can "nest" these so that you have IF <something>, <do something>, <else IF <something>, <do something>, <else IF <something>..etc, etc)