**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.*