ROUNDING
How do you round down to the nearest £0.25 please
Thanks. Bill Ridgeway |
ROUNDING
=ROUND(A1*4,0)/4
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bill Ridgeway" wrote in message ... How do you round down to the nearest £0.25 please Thanks. Bill Ridgeway |
ROUNDING
Hi Bill,
Try =FLOOR(A1,0.25) HTH Martin |
ROUNDING
Hi Bill
Try =FLOOR(A1,0.25) to round up =CEILING(A1,0.25) -- Regards Roger Govier "Bill Ridgeway" wrote in message ... How do you round down to the nearest £0.25 please Thanks. Bill Ridgeway |
ROUNDING
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) "Bob Phillips" wrote in message ... =ROUND(A1*4,0)/4 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bill Ridgeway" wrote in message ... How do you round down to the nearest £0.25 please Thanks. Bill Ridgeway |
ROUNDING
=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. "Bill Ridgeway" wrote: How do you round down to the nearest £0.25 please Thanks. Bill Ridgeway |
ROUNDING
Many thanks for your quick replies.
Regards. Bill Ridgeway |
ROUNDING
I think BoniM intended to say that MROUND rounds to the nearest, *not* that
it will only round up. -- David Biddulph "BoniM" wrote in message ... =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. "Bill Ridgeway" wrote: How do you round down to the nearest £0.25 please Thanks. Bill Ridgeway |
ROUNDING
Yep... Thanx. And I hereby pledge to henceforth only read (and never write)
when I'm suffering from sleep deprivation... ;-) "David Biddulph" wrote: I think BoniM intended to say that MROUND rounds to the nearest, *not* that it will only round up. -- David Biddulph "BoniM" wrote in message ... =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. "Bill Ridgeway" wrote: How do you round down to the nearest £0.25 please Thanks. Bill Ridgeway |
ROUNDING
A pledge that I should also make
"BoniM" wrote: Yep... Thanx. And I hereby pledge to henceforth only read (and never write) when I'm suffering from sleep deprivation... ;-) "David Biddulph" wrote: I think BoniM intended to say that MROUND rounds to the nearest, *not* that it will only round up. -- David Biddulph "BoniM" wrote in message ... =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. "Bill Ridgeway" wrote: How do you round down to the nearest £0.25 please Thanks. Bill Ridgeway |
All times are GMT +1. The time now is 12:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com