AverageIF function returns with a #DIV/0! because the criteria does not exactly match.
I am working with a set of values where there are repeated x values with multiple y values. For example, x value of 10 would have values like -0.5, -0.51, -0.52. I am trying to get the average of these y values for each x value in 0.01 increments.
The averageif work functions works up until a certain point that it just returns with #DIV/0!. When I check the error, the criteria doesn't match the cell on its left. In the photo, the criteria shows as 16.51000....01 when the real criteria (on the left) is 16.51. Where is the error coming from?
The way I typed up the x values in 0.01 increments is typing 0.0 and 0.01 and dragging that down to my target value. I tried the sequence function as well but I get a similar error.
[link] [comments]
Want to read more?
Check out the full article on the original site