[FIXED] How to subtract two numbers with particular decimal increments in Excel

Issue

In Excel (2016, mac) I have two rows of four-digit numbers with two-digit decimals, which have an increment of .25
For example: 1000.25 and 1001.50
The "distance" between the numbers in this example is 5, as we have quarter increments.

Which formula do I need to calculate the distance?

Solution

Just divide the difference by the increment size, something like the following:

=(A3-A2)/0.25

Answered By - BigBen

Answer Checked By - David Goodson (PHPFixing Volunteer)