Hi folks,
I have a tricky little problem that is a difficult one for me to explain, but I'm sure this has a simple solution.
Basically
x = a percentage eg 23%
A = basic amount
B = x percentage of C
C = A + B
How can I put in formulae in the cell for B to allow me to vary the figures used x and A to work out a value for B and also C?
Can anybody help with this one? Is there a function that can deal with this type of problem?
many thanks
Last edited by FCFalkirk; 04-07-2011 at 10:58 AM.
Maybe a ample sheet with what you have and what you need would help
You could have a look at Goal Seek.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Do you mean B to be "x percentage of C" or should it be "x percentage of A"?
Audere est facere
B is x percentage of C. That is the problem I have as the answer B then has to form part of C (A+B=C).Originally Posted by daddylonglegs
I have attached a sample. I have difficulty explaining.
Last edited by FCFalkirk; 04-07-2011 at 09:47 AM.
Solved it now, thanks. Not as complicated as I thought. Just needed to work back from the answer by using applying 1/1.23.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks