Hello everyone,
I am after some help.
I have a spread sheet which has a column which is linked to the adjacent column. It is for working out company mileage claims, basically im inputting the mileage on the left cell for Monday, the the cell to the right will do a calculation or multiplying the mileage. And the next day will be the same etc etc.
Here is the tricky part, I want the formula to keep track of the total mileage, as up to 10000 miles the rate is 1 mile x .45p, anything after that is x 25p.
Ive tried using endless amounts of brackets, colorful language etc to no avail.
Any help would be most appreciated
Many thanks
Bookmarks