Question description:
This user has given permission to use the problem statement for this
blog.
Hi i need a formula to work out a percentage of a different box i.e. i want it to give me the number 12 if i put in 12% of 100
Solved by A. H. in 7 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
15/03/2018 - 07:40
Hi, Welcome to Got It Pro.
User
15/03/2018 - 07:40
hi
Excelchat Expert
15/03/2018 - 07:40
You are looking for a formula to multiply % with 100?
Excelchat Expert
15/03/2018 - 07:41
=12%*100
Excelchat Expert
15/03/2018 - 07:41
Please refer B3 cell.
User
15/03/2018 - 07:41
i am not sure can i put in my questioin on the sheet
Excelchat Expert
15/03/2018 - 07:41
I have applied the formula as required.
User
15/03/2018 - 07:43
how do i do it from here...
Excelchat Expert
15/03/2018 - 07:43
Do you want to multiply A7 and B7 cells?
User
15/03/2018 - 07:44
i think so...
Excelchat Expert
15/03/2018 - 07:44
It is simple multiplication.=A7*B7
User
15/03/2018 - 07:45
Thanks! what if it was just the number 12 instead of 12% and i ant to write the formula in c7 what would i do
Excelchat Expert
15/03/2018 - 07:45
Then you have to divide by 100
User
15/03/2018 - 07:46
Awesome Thanks alot.
Excelchat Expert
15/03/2018 - 07:46
Thank you.
User
15/03/2018 - 07:46
can i ask 1 more thing
Excelchat Expert
15/03/2018 - 07:46
Please Recommend Got It Pro.
Excelchat Expert
15/03/2018 - 07:47
Have a great day ahead. Please visit Got It Pro for new queries.
User
15/03/2018 - 07:47
ok thanks
User
15/03/2018 - 07:47
bye
Excelchat Expert
15/03/2018 - 07:47
Thank you. You are welcome.
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.