Hi All

Can you please help me with an if formula

if A1 is between 0-500 then display A1*.15, otherwise if A1 is between
501-1000 then display A1*.10, otherwise if A1 is greater then 1000 then
display A1*.05.

I know its simple but i just cant work it out! It is the between
501-1000 that is giving me trouble.


Your help is much appreciated.

Thanks
Andrew


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=535397