Column 1 | Column 2 | Column 3 | Column 4 | E |
---|---|---|---|---|
Profit | Sales | Rate | Total | |
2024 June YTD | 149943 | 37373 | 25 | 60000 |
2024 Estimate FY | 291786 (+29%) | 72947 (+47%) | 25 (+2%) | 75797 (47%) |
2023 FY | 225433 | 49595 | 22 | 51956 |
Let’s say I have 2023 FY data and for 2024 till June and then I want to forecast about the remaining months of 2024. can I do this? and how can show the percentage change in the cells ?