I am trying to work out the formula to calculate mileage up to 10 miles at £0.45, and miles above at £0.25.
I have a column that calculates the £ values but when the mileage reaches 11 the who;e column is recalculated to the lower amount.
I need the the calculations up to 10 to remain unchanged.
I have hopefully attached a sample worksheet that might explain better.
Help would be much appreciated. Thank you.
Hi and welcome to the forum,
Use the following instead in G11 copied down
Formula:
=IF(SUM(H$11:H11)<=10,H11*$B$9,H11*$B$11)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you Richard that work a treat.
Glad to have helped and thanks for the rep.
Or with Vlookup
add 0 in A9
add 11 in a11
g11=VLookup($H$21,$A$9:$B$11,2,1)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks