View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Excel is Calculating Incorrectly

Increase the number of decimal places on those cells. You might see
that C10 actually contains 9.6, but it displays as 10 because of the
format used.

Hope this helps.

Pete

On Oct 22, 9:30*am, Mike wrote:
I'm using the below formula:
=IF(F10=0,"0",SUM(C10/F10))

The data entry in F10 is 5. The data entry in C10 is 10. *That should equate
to 200%; however excel keeps giving me 192% as the equation. This is
happening in many of the cells using this particular formula type.

Please assist.

Thanks,
Mike