Hi,
Need help with rounding the numbers. I am working on a quote in which quantity is arrived by dividing the sell price by Total sell price. The condition is the result (quantity) should always be a whole number, I can achieve that by cell formatting but when the calculation is done using handheld calculator the results are different.
I need the result to be same if using excel or handheld device i.e quantity in whole number.
in F3:
=TRUNC(D3/E3)
Best Regards,
Kaper
hi there. which do you need rounding? to round F3, you cannot simply format cells. format cells is only a presentation. use:
=ROUNDUP(D3/E3,0)
for D3 to be rounded to the nearest thousand, try:
=ROUND(E3*F3,-3)
it cannot work when F3 is a formula though, because F3 & D3 are dependent on each other if so
Edit:
you should be getting 133 instead of 132 because you need 132.4795761 number of products. you can't possibly have it lesser
Last edited by benishiryo; 02-03-2014 at 03:55 AM.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
benishiryo,
Thanks for your quick response.The total sell price will increase if your formula [=ROUNDUP(D3/E3,0)] is used in F3.
Qty 133 * 135.87 = 18070.71.
The total sell price is fixed and cannot be changed, we can only manipulate the Qty to achieve 18000. Sorry if I was not clear at start.
Please help
With total sell price and sell price is fixed, the quantity must be interger or decimal. Is it accepted being decimal?
Quang PT
bebo021999,
The quantity must be an integer, decimal is not accepted. Please help, can you also give me a solution if decimal was allowed?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks