i would like to have a set of prices round up or down to the nearest ninth.
for example, 1.15 turns into 1.19. 2.41 turns into 2.39
i would like to have a set of prices round up or down to the nearest ninth.
for example, 1.15 turns into 1.19. 2.41 turns into 2.39
David,
For a number in cell A1
=ROUND(A1,1) -0.01
HTH,
Bernie
MS Excel MVP
"David S" <David S@discussions.microsoft.com> wrote in message
news:C4F2CF1D-5E0F-485B-B49C-B441C0673F79@microsoft.com...
> i would like to have a set of prices round up or down to the nearest
ninth.
> for example, 1.15 turns into 1.19. 2.41 turns into 2.39
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks