S
skydiving3
I was trying to use the IF statement to do the following, but it would not
work. I want to enter a number in cell A1. Then cell B1 will look that
number up (cell A1) in a table:
0-150 = 1
151-300 = 2
301-500 = 3
501-1000 = 4
1001-1500 = 5
1501-over = 6
Once cell B2 finds the right number (1,2,3,4,5, or 6) it will multiply cell
A1*B1.
Please let me know if more explanation is needed. I appreciate the help.
work. I want to enter a number in cell A1. Then cell B1 will look that
number up (cell A1) in a table:
0-150 = 1
151-300 = 2
301-500 = 3
501-1000 = 4
1001-1500 = 5
1501-over = 6
Once cell B2 finds the right number (1,2,3,4,5, or 6) it will multiply cell
A1*B1.
Please let me know if more explanation is needed. I appreciate the help.