Can you help with a spreadsheet formula??

Jo4

Can anyone tell me how to make a cell in a spreadsheet round up to the next £10. I am using Microsoft Excel 2003. Is this possible?

Chippy_Minton

If the number is in A1:

=CEILING(A1,10)

Jo4

Chippy_Minton wrote: »

If the number is in A1:

=CEILING(A1,10)

THANKS!! I have been trying to work that our for months and obviously never found out. Is it in the help and I missed it?:o

Chippy_Minton

It's in the Help ('round nearest') but not an obvious function to try.

Guess what the equivalent is for rounding down?!

Jo4

Chippy_Minton wrote: »

It's in the Help ('round nearest') but not an obvious function to try.

Guess what the equivalent is for rounding down?!

FLOOR??

Chippy_Minton

Yep, got it in one.

custardy

kudos to those that can do it.i could never get the hang of doing formulas in excel

Jo4

Chippy_Minton wrote: »

Yep, got it in one.

I thought it should have been round up or round down.

THANKS for your help though!!

Chippy_Minton

Jo4 wrote: »

I thought it should have been round up or round down.

CEILING and FLOOR are used for rounding up/down to the nearest 'n', e.g. the nearest 10, 5, 33 etc.

ROUND, ROUNDUP and ROUNDDOWN are for rounding to the left or right of the decimal point.

There's also MROUND.

Jo4

Chippy_Minton wrote: »

CEILING and FLOOR are used for rounding up/down to the nearest 'n', e.g. the nearest 10, 5, 33 etc.

ROUND, ROUNDUP and ROUNDDOWN are for rounding to the left or right of the decimal point.

There's also MROUND.

Take it your a computer whiz kid?!?