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)
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.