On Apr 8, 2:17*pm, JE McGimpsey wrote:
That won't work, as it applies one percentage to the entire amount
(rather than 5.2% to the first 29.99, 3% to the next 70, etc.)

FWIW, if it DID work, there's really no reason to use the AND()s. The
only time the second IF statement would be executed if if the first
criterion returns FALSE, so

* *=IF(C4<30, C4*5.2%, IF(AND(C4=30, C4<=99.99), C4*3%, ...

reduces to

* *=IF(C4<30, C4*5.2%, IF(C4<=99.99, C4*3%, ...

In article
,



wrote:
Or modify this to fit your needs
=IF(C4<30,C4*0.052,IF(AND(C4=30,C4<=99.99),C4*0.0 3,IF(AND(C4=100,C4<=199.*99)
,C4*0.025,IF(AND(C4=200,C4<=299.99),C4*0.015,IF(A ND(C4=300,C4<=599.99),C4**0.
015,IF(C4=600,C4*0.01))))))- Hide quoted text -

- Show quoted text -

Thats what I thought, but his statement "I also
need it the work it out accuratley if for exaple 150 is entered then
the cell
would match it up to the 100 to 199.99 and work out that it needs to
calculate it and give 2.5% of 150 as the answer. Anyone help,
please! " made me think that is the way he wanted it, he kind of
contradicts himself between the first and last statements. Thanks for
shortening thast for me, I use to be pretty good with this stuff but
have been out of it for 6 years and its kinda like learning all over
again lol.