Skip to main content

Creating Goals by Increasing a Number by a Set Percentage

  • June 1, 2023
  • 1 reply
  • 13 views

Forum|alt.badge.img

I am trying to generate sales goals in a formula, I have a column with the previous years result (manually entered), I have a % column with my growth target but I cannot figure out how to create a column with a formula that takes the previous result ($) and adds to growth target (%) to create a goal ($)

1 reply

Forum|alt.badge.img+18
  • Inspiring
  • 272 replies
  • June 1, 2023
You could write this as
 
{2022} + {2022} * {Target}
or
{2022} * (1 + {Target})
 
or record your target increase as 140% and keep your formula as-is:
{2022} * {Target}

Hope that helps!