Formula to Calculate Tiered Pricing

[bobzy20]

Hi,

I was looking for a formula that would provide the following.

Any amount below £800 would be calculated (x0.12), and any amount above £800 would then be calculated (x0.09), giving the total £104.28

Cell A = £892.01

Formula
£800 x 0.12 = £96
£92.01 x 0.09 = £8.28

Cell B = £104.28

Any help would be great.

Thanks

 

[Joe4]

For a value in cell A1:

=ROUND((MIN(A1,800)*0.12)+((MAX(A1,800)-800)*0.09),2)

 

[bobzy20]

For a value in cell A1:

=ROUND((MIN(A1,800)*0.12)+((MAX(A1,800)-800)*0.09),2)

Thanks very much, its works very well.

 

[Joe4]

You are welcome.
Glad I was able to help!