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