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

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

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

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

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