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 ?