ExcelBanter - round up to nearest 50p

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - round up to nearest 50p (https://www.excelbanter.com/excel-discussion-misc-queries/264465-round-up-nearest-50p.html)

fazz

round up to nearest 50p

Hello - how do i round a number up to the nearest 50p

T. Valko

round up to nearest 50p

Maybe this...

A1 = some positive number

=CEILING(A1,50)

--
Biff
Microsoft Excel MVP

"fazz" wrote in message
...
Hello - how do i round a number up to the nearest 50p

All times are GMT +1. The time now is 09:59 PM.