want to round a number to the nearest quarter 0.25-0.50-0.45-0.00
 

can somebody help?

want to round a number to the nearest quarter 0.25-0.50-0.45-0.00
 

=ROUND(A2*4,)/4

with your number in A2

for future posts put the question in the body of the message as well


--


Regards,


Peo Sjoblom



"Vangelis" wrote in message
...
can somebody help?

want to round a number to the nearest quarter 0.25-0.50-0.45-0.00
 

If you have the Analysis ToolPak add-in installed:
=MROUND(A1,0.25)

Otherwise:
=ROUND(F1/0.25,0)*0.25

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Vangelis" wrote in message
...
can somebody help?

want to round a number to the nearest quarter 0.25-0.50-0.45-0.00
 

One way:

=ROUND(A1*4,0)/4

In article ,
Vangelis wrote:

can somebody help?