How to do percentages in Excel

F

fnctyusa

I keep a daily total of transactions done per person and a total of all
transactions for the week. i need to know what formula to use to get what
percentage of the total each person done for the week. Example
Jane Doe 18 4 6 5 3 = 36
John Doe 16 4 3 5 5 = 33
total 69
To the right of each name I need it to calcuate the percentage of 69 was
done per person
 
C

Cutter

For Jane Doe

In a cell to the right of the total put the formula =cell containin
the 36)/cell containing the 69

Format that cell as percentag
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentage according to Weightage 3
Percentages 2
Percentage over a date range 3
Percentage to Get Invested Return 2
Rank and Sort 2
Getting a percentage 3
Splitting a number in one cell into other cells 0
Calculating current grade percentage 4

Top