
Originally Posted by
mattiooo
Currency by default rounds up to the nearest penny, so my guess would still be rounding - for example:
If you took 43% of $97.37, the formula is 97.37 * .43 you would get 41.8691, but in a currency column, that would display as $41.87. However under that display is still 41.8691, and that is what is used in subsequent formulas.
Without seeing actual numbers, it's hard for me to say if that is what is happening to you, but that seems what is most likely to me.
One way you can check is to change the formatting of all the currency columns or rows to numbers.
Hope that helps.