In A1 I have a value +1000 total orders.
in A2 I have a value +914 closed orders.
This is 91.4%
I need to calculate how many orders i need to add to a1 and a2 to give me 92% even or just over but not rounded up to 92%.
I know by trial and error that it is 75. therefor A2 becomes 989 and A1 becomes 1075 which is = 92%.
Orders come in often therefor this is dynamic. However a math formula must be the answer and I will make the excel formula from that.
Last edited by wurugu; 06-30-2012 at 05:41 PM.
you could use A1*.92 to give you what A2 needs to be...or A2*.92 to give you what A1 needs to be, but you cant do both at the same time with a formula
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you FDibbins for the quick reply, However, your formulas A1*.92 equals 920 but now A1 is 1006 because we also have to add 6 to the A1 total. 920 divided by 1006 is 91.46%. And A2 *.92 is 840.88 which is below the orders already closed. If you meant A2/.92 that is equal to 993.48 which is greater than the 920 in the A1 calculation? So I'm afraid that doesn't work either.
like i said, you cannot have a formula that will use BOTH numbers to calc each other, based on arriving at 92%...you can either have 1 or the other, either a value in the cell, or a formula.
what you want is not possible with a formula, perhaps some1 can come up with a VBA answer for you
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
try solver see attached
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Sledge hammer for a tack, Martin?
looks like i was looking atthis from totally the wrong angle. my apologies to the OP
well its good to practice solver every now and then
Thank you martinwilson, I can use this, i must enter numbers until I get the %age desired but it is faster than the way I did it. I did change the formula to =(A2+B1)/(A1+B1), which means I only have to enter one integer in B1 to get the same result.
shg your formula works great. Thank you Now I do not have to enter any more than the current numbers in A1 A2 and if the target % changes A3. And it gives the direct answer.
Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks