Cant get my head around this one

"mbys14932" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks to all, I have managed to solve the problem using the formula
> posted by duane. Thanks duane. The only problem is I don't fully
> understand the formula, especially the number 4 in it, what does that
> do?!
>
> =IF(A1<96,0,IF(A1>136,*_4_*+(A1-136)*22/100,(A1-96)*10/100))

You said:
.... add 10% from £96 upto £136 ...
--
David Biddulph

I understand the formula below,

however, the number 4, what does it do?, or can someone give me a breakdown of the formula.

=IF(A1<96,0,IF(A1>136,4+(A1-136)*22/100,(A1-96)*10/100))

I really need to know as i need to do a similar formula for another workout, but with different numbers, if I understood what the 4 in the formula did, I may be able to do it myself.

Thanks.

"mbys14932" <[email protected]> wrote
in message news:[email protected]...
>
> I understand the formula below,
>
> however, the number 4, what does it do?, or can someone give me a
> breakdown of the formula.
>
> =IF(A1<96,0,IF(A1>136,4+(A1-136)*22/100,(A1-96)*10/100))
>
> I really need to know as i need to do a similar formula for another
> workout, but with different numbers, if I understood what the 4 in the
> formula did, I may be able to do it myself.

When you asked the same question last month I gave you the answer:
"You said:
.... add 10% from £96 upto £136 ..."

As an exercise, try calculating what 10% of (£136 - £96) is.

Just as a reminder, your original requirement was as follows:
"so if the amount in A1 is greater that £136, add 10% from £96 upto £136
and then 22% on the ress of the amount."
--
David Biddulph