Rounding up

[Safequip]

Can anyone help please I have a huge spread sheet I need to round up the pennies on, I've started to do this manually but it is going to take me till my pension and I do know that excel has the capabilities of doing this I just can't work out how and would appreciate any advise, see below, first column is the figure I have (this is created by a formula) the second is where I need to get to... any help will be appreciate.


£82.97 £83.00

£82.97 £83.00

£82.97 £83.00

£82.97 £83.00

£82.97 £83.00

£71.87 £71.90

£71.87 £71.90

£71.87 £71.90

 

[Debraj]

Hi Safequip!


I think.. below topic will help you till your pension..


http://chandoo.org/wp/2012/09/28/round-numbers-excel-formulas/


Regards,

Deb

 

[DaveTurton]

assuming the original values are in Column A starting at A2 and the rounded values in column B starting at B2:


formula in B2

=ROUNDUP(A2,1)


Drag down


This is rounding up the Value in A2 to 1 decimal place.

 

[Safequip]

Thanks so much for this, which is fabulous however it rounds up as you say to 1 decimal place is this possible to have is as say £71.81 rounded to £71.85?

 

[Safequip]

Thanks so much for this, which is fabulous however it rounds up as you say to 1 decimal place is this possible to have is as say £71.81 rounded to £71.85?

 

[DaveTurton]

=CEILING(A2,0.05)

 

[Safequip]

Dave thanks, you have no idea how much work this will save me.