Skip to main content

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

 

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!

Reply


Terms & Conditions