Hi!

Try one of these:

=IF(ISNUMBER(A1),A1*LOOKUP(A1,{0;1;501;1001},{0;0. 15;0.1;0.05}),"")

=IF(ISNUMBER(A1),IF(A11000,A1*0.05,IF(A1500,A1*0 .1,A1*0.15)),"")

Biff

"koba" wrote in message
...

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