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

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" <(E-Mail Removed)> wrote in message
news:CA668793-5D9E-4458-B11E-(E-Mail Removed)...
> 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

Thank You it worked perfectly

"Fred Smith" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:CA668793-5D9E-4458-B11E-(E-Mail Removed)...
> > 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
>
>