For example: 0-$500 = 20% 501-$1000 = 15% 1001-$5000 = 12.5% Thank you!
G Guest Sep 3, 2006 #2 One way: =LOOKUP(A1,{0,501,1001},{0.20,0.15,0.125}) with cell formatted as % or look at VLOOKUP function
One way: =LOOKUP(A1,{0,501,1001},{0.20,0.15,0.125}) with cell formatted as % or look at VLOOKUP function
I Ian Sep 3, 2006 #3 =IF(B1<=500, 0.2,IF(B1<=1000,0.15,IF(B1<=5000,0.125,0))) and format as percentage. I've assumed that anything over the maximum in a range goes into the next range (eg.$500.01) and that anything over 5000 results in 0.
=IF(B1<=500, 0.2,IF(B1<=1000,0.15,IF(B1<=5000,0.125,0))) and format as percentage. I've assumed that anything over the maximum in a range goes into the next range (eg.$500.01) and that anything over 5000 results in 0.
G Guest Sep 6, 2006 #4 That's perfect Ian. Thanks. Ian said: =IF(B1<=500, 0.2,IF(B1<=1000,0.15,IF(B1<=5000,0.125,0))) and format as percentage. I've assumed that anything over the maximum in a range goes into the next range (eg.$500.01) and that anything over 5000 results in 0. Click to expand...
That's perfect Ian. Thanks. Ian said: =IF(B1<=500, 0.2,IF(B1<=1000,0.15,IF(B1<=5000,0.125,0))) and format as percentage. I've assumed that anything over the maximum in a range goes into the next range (eg.$500.01) and that anything over 5000 results in 0. Click to expand...
G Guest Sep 6, 2006 #5 That's perfect Ian. Thanks. Ian said: =IF(B1<=500, 0.2,IF(B1<=1000,0.15,IF(B1<=5000,0.125,0))) and format as percentage. I've assumed that anything over the maximum in a range goes into the next range (eg.$500.01) and that anything over 5000 results in 0. Click to expand...
That's perfect Ian. Thanks. Ian said: =IF(B1<=500, 0.2,IF(B1<=1000,0.15,IF(B1<=5000,0.125,0))) and format as percentage. I've assumed that anything over the maximum in a range goes into the next range (eg.$500.01) and that anything over 5000 results in 0. Click to expand...