Multiplication formula

[Mattedwards2019]

Hi all, i have searched the web for a formula that would allow me too multiply the first 10,000 of a number in a cell by 0.45 and the remainder of the number by 0.25 then ideally putting it into 2 separate cells ( one for the 0.45 answer and the other for the 0.25 answer . Although its not a massive issue doing it manually i feel iff there was such a formula it would finish off my spreadsheet which im using for a self assessment tax reclaim! Thanks all

 

[Scott Huish]

How's this?

Excel 2010
	A	B	C
1	20000	4500	2500
Sheet1

Cell Formulas
Range	Formula
B1	=MIN(A1,10000)*0.45
C1	=MAX(0,A1-10000)*0.25

 

[Mattedwards2019]

How could i put both formulas to come from B56 instead of B1 and C1?

 

[Scott Huish]

You said you wanted each part in a different cell. So just change the reference of A1 in both formulas to B56.

Excel 2010
	B	C	D
56	20000	4500	2500
Sheet1

Cell Formulas
Range	Formula
C56	=MIN(B56,10000)*0.45
D56	=MAX(0,B56-10000)*0.25