rounding to the nearest quarter

[grandma13]

I have a cell that contains a formula which results in a
number with 2 decimal places. I need to add to the
formula to make the answer round to the nearest quarter.
like: 1.41 would become 1.50, 1.12 would become 1.00,
1.13 would become 1.25, 1.68 would become 1.75 and 1.80
would become 2.00
Please help!!

 

[Norman Harker]

Hi Grandma13!

Use:
=ROUND(A1*4,0)/4

Or there is an Analysis ToolPak function:

=MROUND(A1,0.25)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[grandma13]

That works perfect!! Thanks so much!

-----Original Message-----
Hi Grandma13!

Use:
=ROUND(A1*4,0)/4

Or there is an Analysis ToolPak function:

=MROUND(A1,0.25)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

"(e-mail address removed)"

 

[Norman Harker]

Hi Grandma13!

Always pleased to help; especially Grandmothers!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.