Calculation of a number in a range
Hmm, this is fun:)
Alright, create a little table first (dashes - signify new column)
......D - .....E - .................F
1) 0 - 100000 - ...........0.15
2) 100001 - 250000 - 0.12
3) 251000 - 500000 - 0.10
Now your formula is:
=A1*(VLOOKUP(A1,$D$1:$F$3,3))
That's it:) I know someone beat me to this, but I had this window open
for an hour:)
Krista wrote:
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
|