ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sum Help (https://www.excelbanter.com/excel-discussion-misc-queries/223772-sum-help.html)

Jim

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

Sheeloo[_3_]

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


Bob I

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




All times are GMT +1. The time now is 02:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com