Forum Discussion
cgriffin6127
Feb 14, 2024Copper Contributor
Excel formula
Need help creating a formula. On my spreadsheet, Column R has 2023 final sales. Column T has 2024 budgeted final sales. Trying to have column U show the %increase/decrease of the 2 columns.
- PeterBartholomew1Silver Contributor
Assuming defined names have been applied to the two columns, the percentage difference is given by
= (budgetedSales - finalSales) / finalSales
In 365 the formula spills to give the entire result. In legacy Excel it would need to be filled down or committed with CSE.