P Peo Sjoblom Oct 1, 2007 #2 =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
=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
R Ron Coderre Oct 1, 2007 #3 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)
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)
