"mbys14932" wrote
in message ...

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(A1136,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