For your value in Cell A20 . . . .
First, build a small table with these values (I put mine in cells
F1:G4):
0_______1.00
2000____0.50
5000____0.33 <-Actually =1/3
10000___0.25
Then, put this formula in Cell B20:
=ROUND(VLOOKUP(A20,$F$1:$G$4,2,1)*A20,0)
Does that help?
Ron
--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=391276