Nikki91775
Member
Hi everyone! I know how to use vlookups, hlookups, etc. However, I am wondering if there is a formula in Excel that can help me with this.
Say I have actual 2013 numbers by month. Jan, Feb, Mar and so on.
Under each of the months I have actual sales numbers and some months have a return value of 1 and some months have zero.
I added a line to add a percentage of 2014 growth. How do I say, given February is 0, but they are going to grow 5% this year and I want it to return a number say 1. Is there any formula you can put in like maybe an IF formula to return a number.
Say I have actual 2013 numbers by month. Jan, Feb, Mar and so on.
Under each of the months I have actual sales numbers and some months have a return value of 1 and some months have zero.
I added a line to add a percentage of 2014 growth. How do I say, given February is 0, but they are going to grow 5% this year and I want it to return a number say 1. Is there any formula you can put in like maybe an IF formula to return a number.