Rounding

[Esradekan]

I need a formula, that will round up amounts to the nearest $2. ie.
if A1 value is $102.50, the total in the next cell (B1) should be
rounded up to $104.00.

I know its easy, but I cant work it out.

TIA Esra

 

[Guest]

Try entering in B1
=A1+2-MOD(A1,2)

 

[Guest]

=CEILING(A1,2)
regards,
Stefi


„Esradekan†ezt írta:

 

[Bernd P]

Hello,

=ROUNDUP(A1/2,0)*2

Regards,
Bernd

 

[Guest]

Thanks Stefi, I'm learning too!
Regards
Ron

=CEILING(A1,2)
regards,
Stefi


„Esradekan†ezt írta:

 

[Guest]

That's the benefit of this forum: I've also learned a lot from other users's
experience.
Regards,
Stefi


„Ron@Buy†ezt írta: