Excel 2007 : Calculation ISSUE

[saustin666]

This is proberly a realy easy thing to fix but not being major excel fourmulas i have no idea how to do it.

I have a milage tracker as i can claim 40p per mile for the first 10,000 and then 25p there after. So i have the details and then a trip mile colum, YTD colum and remaining colum.

I have got it so the remaining colum is 10,000 mins YTD colum, leaving me my remaining mileage allowance, and it does work fine but it contunes to minus out the YTD colum all the way down so after half way down the page it goes to minus miles remaing.

I am trying to get it so it only calulates used miles and will give me a remaining miles figure the same all the way down.

I hope that makes sense

cheers

steve

[Fotis1991]

Hi Steve

Would you like to upload a sample workbook for it??

[Pepe Le Mokko]

Supposing your total mileage is in A1, I suppose you are looking for

Please Login or Register  to view this content.

[saustin666]

Sure here you go....


Attachment 135508

[Pepe Le Mokko]

In E5 enter

Please Login or Register  to view this content.

and pull down as needed

[saustin666]

for some reason the fourmals didnt copy this is how it is at the moment.

Attachment 135515

=max works but i wanted to be able to use the 10000 as in the text. so if the government change the allowance i can just change that cell and not all the worksheet.

cheers

steve

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

[saustin666]

How does this not discribe my problem????

[Pepe Le Mokko]

Maybe try something like " Tracker gives negative mileage "

[royUK]

Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum:

[saustin666]

well thats helpful all you can do is copy and paste

[royUK]

It explains what we expect, but the alternative is feel free not to read our rules & post elsewhere

Looking at your previous posts I don't think you have read the rules at all

[saustin666]

no i havent and i bet hal the people on here havent either.

Dont worry i will post else where at least there might not be twats of moderators on there!

[royUK]

Lovely fellow, good to see you go