Hi


"chrisgoulden"
wrote in message
news:chrisgoulden.22tqmz_1139256904.2383@excelforu m-nospam.com...

I have a worksheet function that gives me a result in a dollar value
with 2 decimals, let's say it produces the following value: $11.85.
Now, the actual value is more like this $11.85983733333 because it's a
result of a much more complex formula, but of course I have it rounded
off to 2 decimal places. I have another formula that takes the above

How you did it? Rounded using ROUND(), set 'Precision as displayed' from
ToolsOptionsCalculations to be checked for a while, or simply formatted
cell as number with 2 decimals. When latter, then formatting affects only
the way, the cell value is displayed, not the value itself.


Arvi Laanemets