| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
I want to be able to round a column of figures to the nearest £100.
So 2341 would be rounded to 2300 and 6566 woud be rounded to 6600. Thanks Nick |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding
=ROUND(A2,-2)
-- David Biddulph "Nick C" wrote in message ... I want to be able to round a column of figures to the nearest £100. So 2341 would be rounded to 2300 and 6566 woud be rounded to 6600. Thanks Nick |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding
Thanks David worked atreat, how can I add to an existing formula?
=IF(B11="",O11,"") rEGARDS, nICK "David Biddulph" wrote: =ROUND(A2,-2) -- David Biddulph "Nick C" wrote in message ... I want to be able to round a column of figures to the nearest £100. So 2341 would be rounded to 2300 and 6566 woud be rounded to 6600. Thanks Nick |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding
You just need to nest the commands: if B11 is blank, round O11 to the
hundreds' place, otherwise this cell is blank. =IF(B11="",ROUND(O11,-2),"") Jim "Nick C" wrote: Thanks David worked atreat, how can I add to an existing formula? =IF(B11="",O11,"") rEGARDS, nICK "David Biddulph" wrote: =ROUND(A2,-2) -- David Biddulph |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding
Thanks Jim
"J Sedoff" wrote: You just need to nest the commands: if B11 is blank, round O11 to the hundreds' place, otherwise this cell is blank. =IF(B11="",ROUND(O11,-2),"") Jim "Nick C" wrote: Thanks David worked atreat, how can I add to an existing formula? =IF(B11="",O11,"") rEGARDS, nICK "David Biddulph" wrote: =ROUND(A2,-2) -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding to 2 | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Rounding off to .48 or .98 | Excel Discussion (Misc queries) | |||
| Rounding | Excel Discussion (Misc queries) | |||
| Rounding | Excel Worksheet Functions | |||
Hybrid Mode
