|
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 ? |
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 ? |
| All times are GMT +1. The time now is 04:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com