Good day. I am looking for some help about percentage function in Excel. First I want to know is it possible to solve this calculation, and if it is what is the way.
So, in Excel sheet I have two cells, one with number and other one in percent.
A1 180.000
B1 90%
C1 ?
Now, in cell C1 there should be a total of which 90% is 180.000.
So the result should be 200.000 , or 180.000*100/90.
But, that result is possible to get only if it would be given this way.
A1 value
B1 %
C1 total
A2 180.000
B2 90
C2 (Fx) Count =A2*100/B2
I want to know if this is the only way of putting values in Excel in order to have correct result. Or, if not, then what function I must choose in order to put 90% in calculation.
Thank you.
Last edited by Hostihugen; 10-22-2011 at 05:37 AM.
Could it be as simple as putting =A1/A2 into A3?
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
Well no, because if you put % into cell for calculation, then you got 2.000.000 as a result. I think that for calculation between a number (180.000) and percentage (90%) like this 180.000, 90% must be involved some kind of function in excel.
If you are trying to do something other than basic division with a percent (as mrice suggested), then it would seem your description of the problem is not clear.
Would you please elaborate?
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
Well you can try yourself if you want. This was a test problem from competition for one bank I was, for a new job. They gave us this problem to put results for three calculations. I am just showing you one of those.
If you put percentage mark (%) in function formula, the result is going bye bye
I am just trying to find out that putting % in header, and putting only numbers below was correct way to do that, so I can put some complain to the HR of that company. They shouldn't give this kind of test to candidates for job, because there is no way that someone can do it.
On the picture you can see how I think that should be done. I already in my post opening showed you how they (Bank) did it. I only want to know if they are mistaken and is this the right way?
Last edited by Hostihugen; 10-24-2011 at 07:06 AM. Reason: Putting picture
Depending how you enter your value - a result is different.
If you put 90 and you mean 90% then you'll get wrong result because 90 is not 90% (it's 9000%), and 0,9 is 90%
Here are some various inputs and results:
Value % Result formula 180000 0,9 200000 =A2/B2 180000 90 200000 =A3*100/B3 180000 90% 200000 =A4/B4
"Relax. What is mind? No matter. What is matter? Never mind!"
Yes, that is the right way I suggested, looking for solution on Internet. But they (Bank) put % into cells, like this.
180000 90%
So I only want a confirmation that solving problem like this is impossible, so I can show them their mistake.
It's not mistake. See example in 3rd row.
"Relax. What is mind? No matter. What is matter? Never mind!"
Yes, I understand now. Sorry for not see this. Thanks everyone.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks