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
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