Share via

Excel Spreadsheet Formula Question

Anonymous
2016-03-30T15:52:16+00:00

Good Morning! I am creating a spreadsheet for our shops vehicle maintenance. I have created it so it automatically adds 5000 to the first row on the sheet that had the mileage inputted. The problem is, I want to continue to add 5000 to the most recent cell updated.

Example:

Truck X:

Service Completed (kms):

A  121543

B  125657

C  129544

D  139552

Truck X needs service every 5000km. I have a cell created for "Next service required" and it currently is a formula of =5000+A which would give me 126543 in my cell. I need the formula to reflect the latest number in the "service completed" column. The column will always be updated with the mileage at time of each service. I hope this makes sense!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Ashish Mathur 101.9K Reputation points Volunteer Moderator
2016-03-30T23:30:54+00:00

Hi,

Try this formula in cell D1

=LOOKUP(1E100,$B$3:$B$50)+5000

Hope this helps.

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-03-30T16:24:42+00:00
    Current Milage 215140 Next Service Required 219,100 Service Required? No
    Date of Service Mileage at Service Description Performed By
    214,100
    02/11/2016 214,102 Oil Change, Electronic Ignition Tune My Automotive

    The number in the "next service required" is only updating from the first "mileage at service" row, and I need it to update with the latest service mileage completed.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-03-30T16:10:47+00:00

    Hi,

    Can you upload some sample data to better understand your question?

    Was this answer helpful?

    0 comments