Hi,
I am building a tool that shows me the effective cost per click for a number of clicks based on some pricing tiers...
<tbody>
</tbody>
I am successfully able to use sumproduct to work out my recommended budget based on the number of clicks I want to buy. Using the formula below, where the number of clicks is in B10 and the table above is stored in the "data" worksheet.
=SUMPRODUCT(--($B$10>data!$C$2:$C$6),$B$10-data!$C$2:$C$6,data!$F$2:$F$6)
That works great.
But I've hit a brain wall when trying to work backwards from a set budget to work out the number of clicks I would receive based on the table above.
What is the most elegant way this can be achieved?
I am building a tool that shows me the effective cost per click for a number of clicks based on some pricing tiers...
Cost From (>=) | Cost To (<) |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
0 | 500 | 0 | 500 | 1.00 | 1.00 | ||||
500 | 900 | 500 | 1000 | 0.80 | -0.20 | ||||
900 | 1250 | 1000 | 1500 | 0.70 | -0.10 | ||||
1250 | 1850 | 1500 | 2500 | 0.60 | -0.10 | ||||
1850 | 1e+99 | 2500 | 1e+99 | 0.40 | -0.20 |
<tbody>
</tbody>
I am successfully able to use sumproduct to work out my recommended budget based on the number of clicks I want to buy. Using the formula below, where the number of clicks is in B10 and the table above is stored in the "data" worksheet.
=SUMPRODUCT(--($B$10>data!$C$2:$C$6),$B$10-data!$C$2:$C$6,data!$F$2:$F$6)
That works great.
But I've hit a brain wall when trying to work backwards from a set budget to work out the number of clicks I would receive based on the table above.
What is the most elegant way this can be achieved?