thrill_Bill
New Member
- Joined
- Feb 23, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello friends,
I am using GROWTH to predict exponential growth with existing data, but I was wondering, do I have to have edit the formula for the corresponding units and the predicted units, everytime I have more actual data for the past month? Are there maybe any ways to add the IF function here?
For January and February I have units of 10000 and 2000 accordingly and my formula for corresponding units would be =(B2:B3;A2:A3) and for predicted units =GROWTH(B2:B3;A2:A3;A4:A12). Now if I have existing data for March, I would have to edit both formulas and this would continue for every upcoming month. Are there any ways to avoid this step?
Thank you.
I am using GROWTH to predict exponential growth with existing data, but I was wondering, do I have to have edit the formula for the corresponding units and the predicted units, everytime I have more actual data for the past month? Are there maybe any ways to add the IF function here?
For January and February I have units of 10000 and 2000 accordingly and my formula for corresponding units would be =(B2:B3;A2:A3) and for predicted units =GROWTH(B2:B3;A2:A3;A4:A12). Now if I have existing data for March, I would have to edit both formulas and this would continue for every upcoming month. Are there any ways to avoid this step?
Thank you.