Thread: Rounding

Hi Guys

Hope someone can help, I'm not great with excel.
I want to write a formula which will round curencey values down to the next whole value if the figure ends in .25 or less and up if over .25.

Examples -

£3.25 would become £3
£2.26 would become £3
£1.20 would become £1
£4.46 would become £4

Anyway thanks for the help

This is a FAR easier solution for you.

Highlight all of the cells you intend to put numbers in. Right click and then select "Format Cells" from the dialogue box that pops up. Select currency and then just set the number of decimal places to 0. Excel will round the numbers to the closest whole value. Enjoy.

What do you want to achieve?

£3.25 would become £3
£2.26 would become £3
£1.20 would become £1
£4.46 would become £4

why does 2.26 go to £3 buy £4.46 goes to £4

if it goes to £5 dominic's solution is fine, otherwise what do you want?

Regards

Dav

Assuming £4.46 would round to £5 try

=CEILING(A1-0.25,1)

Wow that was realy quick guys, thanks for the help
I will try and pass it on in good,

Sorry about the typo I did actaully mean £4.46 would become £5
I'm sure stupid mistakes like that dont make life easier.

I've used both solution and they work great.

Thanks
loads