ROundup

[Esradekan]

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]

Maybe

=CEILING(A1,2)

Try that in B1.

Mike

 

[Esradekan]

Maybe

=CEILING(A1,2)

Try that in B1.

Mike








- Show quoted text -

Works terrific, thanks very much.