Rounding

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
 
N

Nick C

Thanks David worked atreat, how can I add to an existing formula?
=IF(B11="",O11,"")

rEGARDS,

nICK
 
J

J Sedoff

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
 
N

Nick C

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

How to use Ceiling to round? 11
Rounding 6
Rounding to nearest 0.5 in Excel 2007 4
Round up to a specific figure 4
Round time to nearest 15 minutes in decimal format 4
Time Clock Intervals 2
How do I round a number to the nearest 900? 1
Rounding to every 5th whole number 4

Top