| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Help
Hello,
In cell "A1" I have 1000 (total customers) In cell "A2" I have 3% (Churn % (% of cust who choose to cancel service)) In Cell "A3" I have 5% (Growth % - how many customers I gain) In cell "A4" I would like to return the results of A1 - A2 + A3. This is 30 day data. Can you help me with this? Thank you Jim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum Help
You already have the answer for Row 1...
Use this in A4 =A1 - A2 + A3 How have you arranged the data for other 29 days?... "Jim" wrote: Hello, In cell "A1" I have 1000 (total customers) In cell "A2" I have 3% (Churn % (% of cust who choose to cancel service)) In Cell "A3" I have 5% (Growth % - how many customers I gain) In cell "A4" I would like to return the results of A1 - A2 + A3. This is 30 day data. Can you help me with this? Thank you Jim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum Help
Does A3 = 5% of 1000 or 970?
= Jim wrote: Hello, In cell "A1" I have 1000 (total customers) In cell "A2" I have 3% (Churn % (% of cust who choose to cancel service)) In Cell "A3" I have 5% (Growth % - how many customers I gain) In cell "A4" I would like to return the results of A1 - A2 + A3. This is 30 day data. Can you help me with this? Thank you Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
