View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default I am doing a calculation in excel, I am multiplying a figure by a

Use

=ROUND(your formula,2)

to round the result off to 2 decimal places. You can also use ROUNDUP(
) or ROUNDDOWN( ).

Hope this helps.

Pete