Grindle5678
New Member
- Joined
- Aug 18, 2017
- Messages
- 1
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!
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!