Help calculating percentages

Hi there,

If you look at the attached spreadsheet, in Week 1 it shows I spend $35 for 100 clicks.
Now for every 100 clicks I make 2 sales (oto sales conversion rate = 2%).
This equals $14 as my product (oto sales price) is $7.
SO... For Week 2 cell C9, I'd like it to calculate C8 ($35) + my 2% oto sales conversion rate ($14) = $49... etc for the remaining weeks.
How can I do this please?

I can't figure out how to incorporate oto sales price & oto sales conversion rate based on clicks into the equation.

Any help would be SO much appreciated!


Cheers,
Mich

Originally Posted by vlady

maybe like this..

=C8+($D$5*$D$6)*100

Thank you! Awesome. You rock!