elusiverunner wrote:
"Ken Johnson" wrote:
try...
=TRUNC(original formula without the =, 2)
[....]
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))

=if(D5="", "", trunc(d5/10, 2))