I have some data that started with an integer with repeating addition that should end up with an integer again, eg 1 + 0.1 + 0.1 + … that should end up with …, 1.9, 2, 2.1, …, 3, 3.1, … For some reason, sometimes those expected integers end up with a very small number, which I’ve needed data so small, eg #E-15, while I seldomly (if ever) needed to go as log as #E-5. Is there a way for when there’s a number so small, a tolerance, that the number is rounded and the background color is set to something very pale, eg when the number is expected to be 1.5 but it’s instead 1.500000000006, it’s set to 1.5 and the background becomes Light Yellow 4 ? I want it rounded as I don’t want the minute number to keep repeating.
I’m sorry of the topic was already brought up and solved but I didn’t find it in my search.
Thank you kindly for your help