Is there any way to display a rounded number in a cell, but use the original unrounded number when other cells reference that cell in a calculation? It would be a pain to use the components of the rounded cell in the calculation in which i would need the unrounded number.
I need a function that displays a rounded number, but uses the unrounded number in calculations.
Bookmarks