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

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

=IF(A1<501,A1*0.15,IF(A1<1001,A1*0.1,A1*0.05))

or

=IF(A1<1,"",if(A1<501,A1*0.15,IF(A1<1001,A1*0.1,A1 *0.05)))

to ignore zero or negatives.

--

koba Wrote:
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


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