could this type of thing be used to avoid rounding errors?
in some spreadsheets that my boss uses every month, the calculations
produce numbers with long decimals, i.e.,
268.30293302
i have it formatted to two decimal places, which shows 268.30;
however, over time rounding errors occur because those extra decimals
add up & eventually add a .01 to the total.
would using =round fix that???
thanks!
susan
When creating a financial proforma I calculate monthly revenues that need
to
be rounded to nearest $100. How can I combine the formula and [round]
function in the same cell.- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -