Ratios

[KCR]

Hello

Does anyone know how to calculate ratios as percentages in excel?
As an example -

Of 35 visitors 10 are New Visitors and 25 are Returning Visitors = a ratio
of 29:71

Any advice much appreciated.

K

 

[Teethless mama]

A1: holds total visitors
B1: holds New vistors
B2: holds Returning Vistors

=ROUND(B1/A1*100,0)&":"&ROUND(B2/A1*100,0)

 

[Sheeloo]

Enter 10 in A1, 25 in B1

In C1 (New Visitors percentage)
=A1/(A1+B1)*100

In D1 (Returning Visitors)
=B1/(A1+B1)*100

in E1 you can put
=ROUND(C1,0) & ":" & ROUND(D1,0) if you want to see as 29:71
or
=C1 & ":" & D1

 

[Pete_UK]

You are working out the ratios as percentages anyway - you have:

10/35 : 25/35, giving:

28.57% : 71.43%, which you have rounded to:

29 : 71

However, the first expression can also be written as:

10 : 25

In both cases this simplifies to 0.4, or 40%

Hope this helps.

Pete

 

[KCR]

Once again brilliant! Many thanks for your help.

A1: holds total visitors
B1: holds New vistors
B2: holds Returning Vistors

=ROUND(B1/A1*100,0)&":"&ROUND(B2/A1*100,0)