Different Results

[albertmb]

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

 

[Fred Smith]

Yes. Use the Round or Roundup function.

If you need more help, post the formula, the results you are getting, and
the results you want.

Regards,
Fred.

 

[albertmb]

Thank You it worked perfectly

Yes. Use the Round or Roundup function.

If you need more help, post the formula, the results you are getting, and
the results you want.

Regards,
Fred.