Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Help
I have data that contains New Traffic and Returning Traffic. I have to find
out the percentage of New Traffic that Returning Traffic is. What formula would I use for that? Help!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Help
If NT is 10 and RT is 5, then it's 50% or =NT/RT. However, interpreting the
English, these 2 items do not overlap -- it's one or the other, and RT would always be 0% of NT. However, you might want to know the percent RT is of AT ("All Traffic") which would be =RT/(RT+NT) HTH "cempire5" wrote in message ... I have data that contains New Traffic and Returning Traffic. I have to find out the percentage of New Traffic that Returning Traffic is. What formula would I use for that? Help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) |