Thread: Rounding
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Rounding

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


€˛Ron@Buy€¯ ezt Ć*rta:

Thanks Stefi, I'm learning too!
Regards
Ron

"Stefi" wrote:

=CEILING(A1,2)
regards,
Stefi


€˛Esradekan€¯ ezt Ć*rta:

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