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

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

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


"KCR" wrote:

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

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

"KCR" wrote:
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

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

On Oct 22, 4:16*pm, KCR wrote:
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

Once again brilliant! Many thanks for your help.

"Teethless mama" wrote:

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

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


"KCR" wrote:

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