Can anyone tell me the formula for rounding a column of currency up to the
nearest nickel? Thanks
Can anyone tell me the formula for rounding a column of currency up to the
nearest nickel? Thanks
=CEILING(A1,0.05)
Vaya con Dios,
Chuck, CABGx3
"GenoBambino" <GenoBambino@discussions.microsoft.com> wrote in message
news:3DC8C2FC-4706-4FB4-B83F-095FAF47B25E@microsoft.com...
> Can anyone tell me the formula for rounding a column of currency up to the
> nearest nickel? Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks