View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default how do i use the roundup function

Hi,
use
=roundup(your formula,2)
i.e =roundup(A1/A3,2)

"Leprechan" wrote:

I have prepared salary scales using simple formulas where the calculations
are based on a % increase. I would like the answers to be rounded up eg:
$27.997 to be $28.00. I am unclear on how to apply the roundup function ( I
believe that is the one I s/b using..) Do I use roundup in the initial
formula & then copy across the page? Can someone pls provide me with an
example.

Thanks
Debbie