B
Bill Ridgeway
How do you round down to the nearest £0.25 please
Thanks.
Bill Ridgeway
Thanks.
Bill Ridgeway
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
=ROUND(A1*4,0)/4
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
M
MartinW
Hi Bill,
Try =FLOOR(A1,0.25)
HTH
Martin
Try =FLOOR(A1,0.25)
HTH
Martin
R
Roger Govier
Hi Bill
Try
=FLOOR(A1,0.25)
to round up
=CEILING(A1,0.25)
Try
=FLOOR(A1,0.25)
to round up
=CEILING(A1,0.25)
B
Bob Phillips
Sorry, missed the down
=ROUNDDOWN(A1*4,0)/4
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
=ROUNDDOWN(A1*4,0)/4
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
G
Guest
=MROUND(A1-0.125,0.25)
Where A1 contains the number you wish to round. MROUND wil only round up,
subtracting 0.125 forces a correction.
Where A1 contains the number you wish to round. MROUND wil only round up,
subtracting 0.125 forces a correction.
B
Bill Ridgeway
Many thanks for your quick replies.
Regards.
Bill Ridgeway
Regards.
Bill Ridgeway
D
David Biddulph
I think BoniM intended to say that MROUND rounds to the nearest, *not* that
it will only round up.
it will only round up.
G
Guest
Yep... Thanx. And I hereby pledge to henceforth only read (and never write)
when I'm suffering from sleep deprivation... ;-)
when I'm suffering from sleep deprivation... ;-)
G
Guest
A pledge that I should also make
BoniM said:Yep... Thanx. And I hereby pledge to henceforth only read (and never write)
when I'm suffering from sleep deprivation... ;-)
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.