View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
albertmb albertmb is offline
external usenet poster
 
Posts: 81
Default Different Results

Hi Everyone, once again I need your help.

I am deviding a piece of land which is quite big and the division is quite
complicated. The land is divided in two parts which have to be divided, (and
not equally) again. My problem is that when I divide the two parts of the
land seperately I get one result but when I devide the land as a whole
considering the second part of the land as a percentage of the first part I
get a different result. I noticed that the problem is not in the workings
but the way numbers are rounded up. When I try the formulas with small
numbers they work, but with large numbers I get rounding up differences. Is
there a way to avoid this?

Thank you for your kind help and support

Albert