View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shayla2008 Shayla2008 is offline
external usenet poster
 
Posts: 7
Default Formula calculating to the 3rd decimal

I am using simple addition & multiplication formulas and the sum appears to
be calculating to the 3rd decimal which is making my totals unacceptable. My
formatting in the cells are for 2 decimal places. How can I ensure the
formula is also calculating to only the 2nd decimal place?