Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
ROUNDING
How do you round down to the nearest £0.25 please
Thanks. Bill Ridgeway |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
ROUNDING
Hi Bill,
Try =FLOOR(A1,0.25) HTH Martin |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
ROUNDING
Many thanks for your quick replies.
Regards. Bill Ridgeway |
#8
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding | Excel Worksheet Functions | |||
rounding help | Excel Discussion (Misc queries) | |||
Rounding | Excel Discussion (Misc queries) | |||
Rounding | Excel Discussion (Misc queries) | |||
Rounding | Excel Discussion (Misc queries) |