I am looking for a way to take the weight input in cell "G2" and use it to calulate the below information:
Less than 150 pounds = 20 Points
150 to 174 pounds = 22 Points
175 to 199 pounds = 24 Points
200 to 224 pounds = 26 Points
225 to 250 pounds = 28 Points
250 to 275 pounds = 30 Points
275 to 300 pounds = 31 Points
300 to 325 pounds = 32 Points
325 to 350 pounds = 33 Points
Over 350 pounds = 34 Points
And place it in cell "D20".
I have been looking and I see that Excel only allows 7 arguments in an if statement. How would I go about putting all this into a function.
To clarify:
D20=G2<150 I need it to put 20 in the cell and so on for all of the above. Should this be an if statement at all?
Bookmarks