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