First off, I want to thank anybody who takes the time to read this question and apologize if the topics within this question are available in other threads. I wasn't able to find a thread based on any keywords imaginable from my perspective.

I'd like to compare a wide range of data. For my spreadsheet I used VLOOKUP to pull two numbers; more specifically the exact numbers of 76.1 & 76.

Then I have Excel subtract the difference between the two, which should be simply 0.1, which is a target number that I need to match.

The cell displays "0.1" but when I double click on the value it doesn't display 0.1. Instead it displays 0.0999999999999943. Sometimes Excel seemingly does this on some computers and on others it doesn't. Why does this happen? I want to say it must be a setting I'm completely unaware of at the moment.

Now, I did try the ROUND function. However, as you can imagine, when I apply the ROUND function to every other calculation I suddenly see that a bunch of my other target numbers don't match because of differences in rounding.

Anybody have any ideas of what's going on here?