Use:

=IF(G12<=50000,100,IF(G12<=500000,0.23%*G12,IF(G12 <=2500000,1150+0.18%*(G12-500000),IF(G12<=5000000,4750+0.15%*(G12-2500000),IF(G12<=21500000,8500+0.1%*(G12-5000000),25000)))))


for the rounding, you can use:
=MROUND(3040.14,0.05)
for this function, you require the Analysis ToolPak addin. This can be
done by going to Tools Addins. Check the Analysis ToolPak checxkbox.


Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374116