Hi
Was looking for some help if anybody has any ideas?
I am currently working on building a spreadsheet that will calculate mileage rate depending on what miles (cumulative) have been traveled per month. I have got the nested formula working but it is calculating the cost on the cumulative figure and not the actual mileage traveled for the particular month.
I have spent alot of time but cannot get it to calculate on the individuals month total. I think i need to add into the formula to minus previous cumalative figure from current and multiply(taking into consideration all the rates that could be applicable to the total mileage)
Thanks
M
Bookmarks