Creating Goals by Increasing a Number by a Set Percentage

[nicole_e]

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 ($)

 

[Stephen_Orr1]

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!