Hello! I'm trying to figure out a formula that would allow me to calculate what % from column C would be required to get 75% of charges from column A. In the chart below, I have the charges in column A, the target in column B, and the % required to Meet target (B2/A2) in column C. Based on the sample data, 75% of the charges would be $607.50 so the rate I'd need to achieve this should come out to about 52% based on column C, but I'm not sure how to calculate this with a formula. Any help is appreciated, thanks in advance!
Charges | Target | % Needed to Meet Target |
$100 | $12 | 12% |
$70 | $35 | 50% |
$100 | $52 | 52% |
$95 | $60 | 63% |
$100 | $66 | 66% |
$95 | $75 | 79% |
$100 | $82 | 82% |
$50 | $45 | 90% |
$100 | $95 | 95% |