Re: formulas, percentage

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Apr 8, 2:17 pm, JE McGimpsey <jemcgimp...@xxxxxxxx> 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
<da6d5ddb-6f30-4c5f-9377-21e13d0bc...@xxxxxxxxxxxxxxxxxxxxxxxxxxx>,



 emcco...@xxxxxxxxxxxx wrote:
Or modify this to fit your needs
=IF(C4<30,C4*0.052,IF(AND(C4>=30,C4<=99.99),C4*0.03,IF(AND(C4>=100,C4<=199.­99)
,C4*0.025,IF(AND(C4>=200,C4<=299.99),C4*0.015,IF(AND(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.

.

Relevant Pages

  • Re: More disgraceful police behaviour.
    ... *is* a good reason for her to have been assaulted then I will eat my ... that there could be no scientific explanation for why the sergeant ... prisoner to shut up and listen to what I am telling him. ... in a cell (forcibly so, if required, but not in the manner that she ...
    (uk.legal)
  • Re: URGENT - Please take action now.
    ... of conception, what is present is a *single cell*. ... that could reasonably be deduced to be a conscious entity that is able ... You've not been able to give a reason for this decision despite my asking you, so I can only conclude it's an arbitrary decision. ...
    (uk.religion.christian)
  • Re: More disgraceful police behaviour.
    ... *is* a good reason for her to have been assaulted then I will eat ... All of these matters, incidentally, are in the best interests of the prisoner. ... While all of this is going on you have other prisoners banging on their cell doors demanding attention, you have officers coming in and wanting prisoners released to interview rooms for interviewing, you have police surgeons attending to obtain blood samples, the telephones are ringing non stop, you have traffic officers with arrested drink drivers who want you to handle the evidential breath test procedure as soon as possible. ...
    (uk.legal)
  • Re: Learning to use decorators with classes
    ... and it's a FAQ FWIW - but since there's no ... The reason we have to explicitly mention it as first ... this method object, it inserts the instance as first ... IOW, and to make a long story short, calling ...
    (comp.lang.python)
  • RE: Restrictions on Addresses
    ... mode)then drag command button onto main sheet) onto your main sheet, ... If the end user selects a cell containing an address then clicks this ... blacklisting in the message box when the address of the selected cell is ... and where the reason would be entered? ...
    (microsoft.public.excel.misc)