multiply by%%

[caroline h]

hi.

i need help. is there a formula to solve the following

€ 500.00 total. i want to get 20% on the first €200 of the total and 30% on the balance

can anyone help please.

ch

[Richard Buttrey]

Hi,

Rather than hard code all the values in a formula, put 500 in A1, 200 in A2, 30% in B1 and 20% in B2.

Now just use the formula

Please Login or Register  to view this content.

HTH

[martindwilson]

since 20 of 200 is 40
=40+(A1-200)*30%
or are you trying to calculate for different amounts?

[caroline h]

thanks all,

ye didn't explain it properly.

the first 200e of any number is taxable @20% an balance |@30%

the original amount could even be less than 200e.

any ideas!

thanks

[shg]

=20%*a1 + 10%*max(0, a1-200)

[caroline h]

Thank you this sorts my problem. Cheers!