Calculation of a number in a range
=A1*LOOKUP(A1,{0,100001,250001},{0.15,0.12,1})
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Krista" wrote in message
...
I need to create a formula for the following:
If A1=any number from 0 to 100,000 then A1*.15
If A1=any number from 101,000 to 250,000 then A1*.12
If A1=any number from 251,000 to 500,000 then A1*.10
Any suggestions?
Thanks much!
--
Krista
|