In cell C1, enter in a number from 1-10, then in cell C2, depending on the number in C1, a dollar amount will appear.
If C1 = 10, then C2 is 262.50
If C1 = 9, then C2 is 259.88 etc...
10 - 262.50
9 - 259.88
8 - 257.25
7 - 254.63
6 - 252.00
5 - 249.38
4 - 246.75
3 - 244.13
2 - 241.50
1 - 238.88
Of course, I can set up the formula up to 7 IF's. What is the best way to go beyond 7?
One column is where 1-10 would be entered, and the 2nd column is where I want 238.88-262.50 to show up. The 2nd column would have the formula.
This is what I have..
=IF(C32=1,238.88,IF(C32=2,241.5,IF(C32=3,244.13,IF(C32=4,246.75,IF(C32=5,249.39,IF(C32=6,252,IF(C32=7,254.63,0)))))))
This message was edited by icka on 2002-03-27 13:04
If C1 = 10, then C2 is 262.50
If C1 = 9, then C2 is 259.88 etc...
10 - 262.50
9 - 259.88
8 - 257.25
7 - 254.63
6 - 252.00
5 - 249.38
4 - 246.75
3 - 244.13
2 - 241.50
1 - 238.88
Of course, I can set up the formula up to 7 IF's. What is the best way to go beyond 7?
One column is where 1-10 would be entered, and the 2nd column is where I want 238.88-262.50 to show up. The 2nd column would have the formula.
This is what I have..
=IF(C32=1,238.88,IF(C32=2,241.5,IF(C32=3,244.13,IF(C32=4,246.75,IF(C32=5,249.39,IF(C32=6,252,IF(C32=7,254.63,0)))))))
This message was edited by icka on 2002-03-27 13:04