Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Different Results
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Different Results
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
v-look up - no results | Excel Worksheet Functions | |||
More MIN() results..? | Excel Worksheet Functions | |||
Why Different results | Excel Discussion (Misc queries) | |||
different results | Excel Discussion (Misc queries) | |||
Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions |