Rounding issue with Excel and dollar values
Current Issue just discovered talking to MS Excel Support to see if there is a work around or if someone is solving this error.
Issue is that when you place values in a cell and do a =ROUND function to format a currency value it rounds down not up. i.e. Summing to Cells and trying to find tax for the two values return in correct value.
=ROUND ($33.165, 2), returns 33.16 and not 33.17. This is a major show stopper for financial calculations and worksheets.
If you always want it to round up, use ROUNDUP()