how do I round 3.30 to the nearest quarter. 3.30=3.25

B

Bob Phillips

=ROUND(A1*4,0)/4

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding to the nearest quarter 1
Round numbers to get to the nearest 0.09 7
How can I Round up to the nearest .25 11
rounding decimals to nearest quarter 4
Round to nearest quarter 5
round numbers to the nearest quarter? 3
How can you round a number to the nearest 900? 3
ROUNDING NUMBERS 3

Top