Rounding numbers into .25 intervals

[boe]

I'd like to have a subtraction cell that rounds numbers to either of these 4
decimals past the whole integer
0
..25
..5
..75

e.g 6.75 - 2.33 = 4.5

Thank you

 

[Bob Phillips]

Boe,

Here is one way

=ROUND((6.75 - 2.33)*4,0)/4

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[boe]

Thank you

Boe,

Here is one way

=ROUND((6.75 - 2.33)*4,0)/4

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)