Question description:
This user has given permission to use the problem statement for this
blog.
Hi there I got cut off from the last session and didn't get the chance to see my answer... can you help again?: I want to find a formula that calculates a percentage of a cell. For instance, if the total in cell A is 100 and the total in cell B is 10 I want cell C to say that B is 10% of A. can you help?
Solved by F. Y. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/11/2017 - 01:48
hi
Excelchat Expert
29/11/2017 - 01:49
are you there??
User
29/11/2017 - 01:49
hello yes I am
Excelchat Expert
29/11/2017 - 01:50
so you want in c answer should be 10
Excelchat Expert
29/11/2017 - 01:50
10%
User
29/11/2017 - 01:50
yes a percentage of the 2
Excelchat Expert
29/11/2017 - 01:50
like that
User
29/11/2017 - 01:51
hang on, can I try?
Excelchat Expert
29/11/2017 - 01:51
what i have done right now
Excelchat Expert
29/11/2017 - 01:51
yes definetly
User
29/11/2017 - 01:52
I didn't see what the formula was
Excelchat Expert
29/11/2017 - 01:52
formula is =a1/b1
User
29/11/2017 - 01:52
ah, ok
Excelchat Expert
29/11/2017 - 01:52
you put =a2/b2
Excelchat Expert
29/11/2017 - 01:53
and then put percentage sign
Excelchat Expert
29/11/2017 - 01:53
i have direct use the values in formula
Excelchat Expert
29/11/2017 - 01:53
oh sorry make formula =b2/a2
User
29/11/2017 - 01:53
Sorry where do I put the % sign?
Excelchat Expert
29/11/2017 - 01:54
there is percent sign above
Excelchat Expert
29/11/2017 - 01:54
below the data tab click that
Excelchat Expert
29/11/2017 - 01:55
click format as percent button which is below data tab
Excelchat Expert
29/11/2017 - 01:55
it is off "%" sign
User
29/11/2017 - 01:56
ah, ok I got it. In my excel I should be able to copy the formula
Excelchat Expert
29/11/2017 - 01:56
ok
Excelchat Expert
29/11/2017 - 01:57
thanks for choosing us
User
29/11/2017 - 01:57
thanks for the help
Excelchat Expert
29/11/2017 - 01:57
:)
Excelchat Expert
29/11/2017 - 01:57
please rate us
User
29/11/2017 - 01:57
will do
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
