ExcelBanter - ROundup

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ROundup (https://www.excelbanter.com/excel-worksheet-functions/164217-roundup.html)

Esradekan

ROundup

I thought I posted this but I cant find it. Apologies if this is
repeating.

But

I need a formula, for cell B1, that will roundup the figure in A1 to
the nearest $2

ie, if A1 = $22.50, the figure in B1 needs to be $24.00

Anyone got any ideas?

TIA
Esra

Mike H

ROundup

Maybe

=CEILING(A1,2)

Try that in B1.

Mike

"Esradekan" wrote:

I thought I posted this but I cant find it. Apologies if this is
repeating.

But

I need a formula, for cell B1, that will roundup the figure in A1 to
the nearest $2

ie, if A1 = $22.50, the figure in B1 needs to be $24.00

Anyone got any ideas?

TIA
Esra

Esradekan

ROundup

On Oct 31, 10:31 pm, Mike H wrote:
Maybe

=CEILING(A1,2)

Try that in B1.

Mike

"Esradekan" wrote:
I thought I posted this but I cant find it. Apologies if this is
repeating.

But

I need a formula, for cell B1, that will roundup the figure in A1 to
the nearest $2

ie, if A1 = $22.50, the figure in B1 needs to be $24.00

Anyone got any ideas?

TIA
Esra- Hide quoted text -

- Show quoted text -

Works terrific, thanks very much.

All times are GMT +1. The time now is 01:53 PM.