# 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.