Formula help -

[Grindle5678]

im a bit of a rookie to Excel and I cant find an exact answer to my question.
Basically I want to get picture 1( https://i.stack.imgur.com/8E5zv.png ) to do what picture 2 ( https://i.stack.imgur.com/LXJhq.png ) is showing. Its probably a really easy question.
So any value total over 10,000 will be charged at the 25p rate and any value below 10,000 will be charged a the 40p rate.
so cumulatively, one person may have claimed 9999 miles since starting and they put in a new expense claim for 10 miles, I would like the 1 mile to go to the 40p rate and the other 9 to the 25p rate.
What sort of formula would I need?
Thanks for any help in advance!

 

[AlanY]

try this

Excel 2012
	A	B
1		9956
2		49
3		44
4		5
Sheet1

Cell Formulas
Range	Formula
B3	=MIN(B2,10000-B1)
B4	=B2-B3