Forum Discussion

cgriffin6127's avatar
cgriffin6127
Copper Contributor
Feb 14, 2024

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.

  • cgriffin6127 

    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.

Resources