Rounding
Sorry that it has taken so long for me to get back to you, Ken. I have tried
your suggestion and it works a treat. However, cells that do not have values
in have now got this - "#VALUE!" without the " were they were blank before
getting values inserted.
I have tried to manipulate the formula to try and get blank cells when there
is no data, but to no luck. The formula before the "TRUNC" statement looks
like this =IF(OR(D5=""),"",(D5/10))
--
Steven.
In God we trust, all others we virus scan.
"Ken Johnson" wrote:
elusiverunner wrote:
Thanks for your reply Ken, but the cells that require the lack of rounding
already has a formula in it. Is there a way I can merge this with other
formula?
Hi Steven,
What is that formula?
Or try...
=TRUNC(original formula without the =, 2)
Ken Johnson
|