software

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: www.excelforum.com/member.php...oamp;userid=28639
View this thread: www.excelforum.com/showthread...hreadid=535397Hi!

Try one of these:

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

=IF(ISNUMBER(A1),IF(A1gt;1000,A1*0.05,IF(A1gt;500,A1*0 .1,A1*0.15)),quot;quot;)

Biff

quot;kobaquot; gt; wrote in message
...
gt;
gt; Hi All
gt;
gt; Can you please help me with an if formula
gt;
gt; if A1 is between 0-500 then display A1*.15, otherwise if A1 is between
gt; 501-1000 then display A1*.10, otherwise if A1 is greater then 1000 then
gt; display A1*.05.
gt;
gt; I know its simple but i just cant work it out! It is the between
gt; 501-1000 that is giving me trouble.
gt;
gt;
gt; Your help is much appreciated.
gt;
gt; Thanks
gt; Andrew
gt;
gt;
gt; --
gt; koba
gt; ------------------------------------------------------------------------
gt; koba's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28639
gt; View this thread: www.excelforum.com/showthread...hreadid=535397
gt;

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

or

=IF(A1lt;1,quot;quot;,if(A1lt;501,A1*0.15,IF(A1lt;1001,A1*0.1,A1 *0.05)))

to ignore zero or negatives.

--

koba Wrote:
gt; Hi All
gt;
gt; Can you please help me with an if formula
gt;
gt; if A1 is between 0-500 then display A1*.15, otherwise if A1 is between
gt; 501-1000 then display A1*.10, otherwise if A1 is greater then 1000 then
gt; display A1*.05.
gt;
gt; I know its simple but i just cant work it out! It is the between
gt; 501-1000 that is giving me trouble.
gt;
gt;
gt; Your help is much appreciated.
gt;
gt; Thanks
gt; Andrew--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=535397