View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chev320 Chev320 is offline
external usenet poster
 
Posts: 13
Default Rounding Formula

I know this is a simple one for you guys, but i just cant see it..
My dollar amount equals $1.17 and i want to round up to 1.20.
I have tried Ceiling & round & roundup with no luck..

=D28/L3+L35 (this is my formula so far)

Thanks