Anyone good with formulas? excel?
 

I need to work out this.

Basically I have this to give me a true CPM on my traffic.

=Price/(100%-Bounce)

However I would like it so I can provide a max true CPM and it will adjust the price accordingly.

Anyone know what to do? :)

no clue, here's a bump for ya tho.

Not sure if you are buying or selling, I'm assuming buying.

Column A = Bounce rate in percentage (whole number... i.e. 50)
Column B = Price you paid per 1000
Column C = Adjusted amount you paid

=B1/((100-A1)*0.01)

Hmmm. Not exactly sure what you need but I have a ton of experience with media math. can you try to explain it differently?

did you figure this out yet? if not help me out, I is an excel fella :winkwink: