How can I substract the lowest value from the highest value in a .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am calculating mileage. I need to subtract the lowest value from the
highest value out of several values in a group to get the miles driven.
 
Set your control source or a text box in the group header or footer to:
=Max([MileageReading])-Min([MileageReading])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Powerpoint image ordering on a single slide 3
Increment value for sorting 7
Trying to find additional ranges outside of min, max, and average 2
Ranking, I think 3
Value match with an array 1
MIN will not find lowest of calculated values How? 5
Subtracting Values from a Ranked List 4
Excel Forms Spin Button - Return to 1 after max value 0

Back
Top