Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage Formula Help
I have a spreadsheet: B2, 848 = New Traffic; B3, 47 = Returning Traffic. I
need to figure out what percentage of Returning Traffic is New Traffic. I did =(B3/B2)*100%. Can someone please tell me if this is right, and if not, what the correct formula would be to get the result percentage? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage Formula Help
Just use =B3/B2 and format as a percentage
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "cempire5" wrote in message ... I have a spreadsheet: B2, 848 = New Traffic; B3, 47 = Returning Traffic. I need to figure out what percentage of Returning Traffic is New Traffic. I did =(B3/B2)*100%. Can someone please tell me if this is right, and if not, what the correct formula would be to get the result percentage? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage Formula Help
Leave out *100, just type =B3/B2%.
"cempire5" wrote in message ... I have a spreadsheet: B2, 848 = New Traffic; B3, 47 = Returning Traffic. I need to figure out what percentage of Returning Traffic is New Traffic. I did =(B3/B2)*100%. Can someone please tell me if this is right, and if not, what the correct formula would be to get the result percentage? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage Formula Help
And of course that is telling you the Returning Traffic as a percentage of
New Traffic. If the OP wants New Traffic as a percentage of Returning Traffic it would be =B2/B3. -- David Biddulph "Bob Phillips" wrote in message ... Just use =B3/B2 and format as a percentage "cempire5" wrote in message ... I have a spreadsheet: B2, 848 = New Traffic; B3, 47 = Returning Traffic. I need to figure out what percentage of Returning Traffic is New Traffic. I did =(B3/B2)*100%. Can someone please tell me if this is right, and if not, what the correct formula would be to get the result percentage? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage Formula | Excel Discussion (Misc queries) | |||
Percentage Formula | Excel Discussion (Misc queries) | |||
percentage formula | Excel Worksheet Functions | |||
Formula for percentage | Excel Discussion (Misc queries) | |||
Percentage formula | Excel Worksheet Functions |