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