Thread
:
Rounding to nearest 5 cents in excel
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
usnst
Posts: n/a
Rounding to nearest 5 cents in excel
Can anyone provide me with a formula that can round a price to the nearest 5
cents? for example 11.33 would be 11.35 11.36 would be 11.35 11.38 would be
11.40. So the price would always end in a '5' or a '0'.
Reply With Quote