Rounding Formula
Nickel?
"Chev320" wrote:
Actually i am trying to make the dollar amount go up to the next nearest
nickel.
When i tried the ceiling function it went up more that what i wanted it to.
The 1.17 should be 1.20
and another line was 1.13, should be 1.15.
Does that explain better?
Thanks again
"Chev320" wrote:
I know this is a simple one for you guys, but i just cant see it..
My dollar amount equals $1.17 and i want to round up to 1.20.
I have tried Ceiling & round & roundup with no luck..
=D28/L3+L35 (this is my formula so far)
Thanks
|