Try one of these:

Requires the Analysis ToolPak add-in be installed for Excel versions prior
to Excel 2007:

=MROUND(A1,0.25)

This one will work in any version:

=ROUND(A1/0.25,0)*0.25

--
Biff
Microsoft Excel MVP


"ajeuck" wrote in message
...
How do I round a dollar amount to the nearest .25

i.e. 11.17 to 11.25, 11.37 to 11.50, 11.67 to 11.75 and so on.....