Hi - I am attempting to create a "round" formula that will display in the cell to the nearest $0.05. I know how to get the result to a specified number of decimal places but this one has me at a loss as to how to proceed. Any assistance is appreciated.
Hello,
try
=CEILING(A1,0.05)
Thanks a lot for answers to both of my questions. Both ideas worked beautifully!
=round(a1/0.05, 0)*.05
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks