How do I round to the nearest 25 cents in Excel?
 

How do I round to the nearest 25 cents in Excel?

How do I round to the nearest 25 cents in Excel?
 

one way

number is in A1
=ROUND(A1/25,2)*25
formatted to two fixed decimals


--
Greetings from New Zealand

" wrote
in message ...
How do I round to the nearest 25 cents in Excel?

How do I round to the nearest 25 cents in Excel?
 

Try this:

With
A1: (a number)
B1: =ROUND(A1/0.25,0)*0.25

Does that help?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

How do I round to the nearest 25 cents in Excel?