Thread
:
ROUNDING NUMBERS
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Elkar
external usenet poster
Posts: 964
ROUNDING NUMBERS
Try this:
=ROUND(A1/0.25,0)*0.25
HTH
Elkar
"JOHN" wrote:
How do I round a dollar amount to the nearest quarter?.... I only find
formulas in help to round to the nearest decimal place.
Reply With Quote
Elkar
View Public Profile
Find all posts by Elkar