Rounding

  • Thread starter Thread starter Nick C
  • Start date Start date
N

Nick C

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
 
Thanks David worked atreat, how can I add to an existing formula?
=IF(B11="",O11,"")

rEGARDS,

nICK
 
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
 
Thanks Jim

J Sedoff said:
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
Click to expand...
 

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.

Ask a Question

Similar Threads

Round-Up question 2
Format cell to the nearest 100 4
Round formula 1
advice on rounding or ceilng a 24 hour time value 3
rounding up to nearest specified whole number 1
Round time to nearest 15 minutes in decimal format 4
Formula Help 1
Round Down to the nearest multiple 2

Back
Top