| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating percentage
I don't know how to explain this. Following is the data in the range A1:D11.
I want to replace all ? with formulas so that it will calculate the CHANCE percentage based on the BASE and PICK. Base Pick Chance Chance % 12 1 1 ? 3160 210 1 ? 82160 1330 1 ? 1581580 5985 1 ? 24040016 20349 1 ? 300500200 54264 1 ? 3176716400 116280 1 ? 28987537150 203490 1 ? 231900297200 293930 1 ? 1646492110120 352716 1 ? |
|
#2
|
|||
|
|||
|
Do you mean to calculate Pick as a percentage of Base? If so in the chance %
column enter =B2/A1 and format as percentage. "mac_see" wrote in message ... I don't know how to explain this. Following is the data in the range A1:D11. I want to replace all ? with formulas so that it will calculate the CHANCE percentage based on the BASE and PICK. Base Pick Chance Chance % 12 1 1 ? 3160 210 1 ? 82160 1330 1 ? 1581580 5985 1 ? 24040016 20349 1 ? 300500200 54264 1 ? 3176716400 116280 1 ? 28987537150 203490 1 ? 231900297200 293930 1 ? 1646492110120 352716 1 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
| Calculating Percentages with Variables | Excel Worksheet Functions | |||
| How can I conditional format to show either a percentage or a whol | Excel Discussion (Misc queries) | |||
| percentage of sales | Excel Worksheet Functions | |||
| percentage of growth | Excel Worksheet Functions | |||
Linear Mode
