Excel Formula Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data consisting of New Traffic and Returning Traffic. I need to find
out the percentage of New Traffic that is Returning Traffic. What formula do
I use? Help!!!
 
I have exact traffic numbers for each month Jan-Sep '06-'07. (Ex. B1 labeled
Jan '06; B2 New Traffic 848; B3 Returning Traffic 47 -- C1 labeled Jan '07;
C2 New Traffic 583; C3 Returning Traffic 282. In the original spreadsheet I
do have the variance % of Returning Traffic between '06-'07 per month. Now
they want to know what the % of New Traffic is Returning Traffic.

I started another spreadsheet that now includes the data as described above.

I was thinking I would take the variance % of New Traffic '06 to '07 and the
variance % of Returning Traffice '06 to '07 but don't know how to write a
formula for that. Would that be correct?
 
Back
Top