Hi.
I wonder how many percent the value "X" represents a total?
example: In cell "A2" have the value 1200, and in cell "B2" have the value 200.
Then the value 200 represents 16.67%. how I do it in excel?
Hi.
I wonder how many percent the value "X" represents a total?
example: In cell "A2" have the value 1200, and in cell "B2" have the value 200.
Then the value 200 represents 16.67%. how I do it in excel?
Last edited by marreco; 06-02-2012 at 09:03 PM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Do you mean...
Format cell as percentage...
=B2/A2
HTH
Regards, Jeff
Hi.
Perfect!!!
thank you!!!
You're welcome…glad it worked for you and thanks for the feedback...![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks