• 100% Satisfaction Guarantee
The-PC-Guy, Computer Manager
Category: Computer
Satisfied Customers: 2037
Experience:  20 years experience providing remote computer support
62934938
The-PC-Guy is online now

# formula building on excel

### Resolved Question:

formula building on excel
Submitted: 3 years ago.
Category: Computer
Expert:  James K. replied 3 years ago.
Hello

My name is James

what issue are you having ?
Customer: replied 3 years ago.

 January 7,250.00 4 20 51 4 78 February 7,250.00 5 27 70 5 108 March 7,250.00 7 33 86 7 132 April 7,250.00 8 38 98 8 151 May 7,250.00 8 42 108 8 166 June 7,250.00 9 45 116 9 178 July 7,250.00 9 47 122 9 188 August 7,250.00 10 49 127 10 196 September 7,250.00 10 51 131 10 202 October 7,250.00 10 52 135 10 207 November 7,250.00 11 53 137 11 211 December 7,250.00 11 54 139 11 214

Hi James,

The problem I'm having is in the above column 3.4.5.6 i use this formula to get =ROUND(Q59*\$B\$49,0) the numbers. The thing is that these numbers arrive from another growth formula. So i column 3 ...the 4 becomes 11 by december, what i what is to get the unit increase for each month.....so January begins with 4...February becomes 5 where february should be 1 because there was an increase in just 1 point. How can i do this using one formula without adding more columns .

Thanks

Expert:  James K. replied 3 years ago.
Thanks
let me send this to the programing section
Customer: replied 3 years ago.

Ok cool

Expert:  The-PC-Guy replied 3 years ago.

it appears the expert you were working with is no longer availible.

It would be helpful if you could send an example workbook.

www.wikisend.com

paste that number here
Customer: replied 3 years ago.

Hi Andrew,

I have highlighted the table

Thanks

Expert:  The-PC-Guy replied 3 years ago.
give me a few to take a look at it
Expert:  The-PC-Guy replied 3 years ago.
i have the document open

still not quite following what you want

you want to know the number of units change between months, so for example

jan to feb would be 1

feb to mar would be 2

and you want to have this displayed instead of 4, 5, and 7?
Customer: replied 3 years ago.

Yes you see the number begins with 4 and grows into 11 . So when you add the year total of the column it should equal to 11

Expert:  The-PC-Guy replied 3 years ago.
let me know if this is what you are looking for

the number for jan is still the old number as there is no previous year december for it to pull the change from.

---------------------------------------------------------------------------------------------------------------

let me know if you have any questions, problems, or concerns

PLEASE DON'T FORGET TO RATE SO I AM PAID FOR MY TIME

IT WILL NOT COST ANYTHING ADDITIONAL BEYOND THE VALUE OF YOUR QUESTION

TO RATE, CLICK THE SMILEY FACES BENEATH THIS ANSWER

Do not rate negatively, instead continue the conversation with me so I can address any of your concerns

---------------------------------------------------------------------------------------------------------------

if you have any questions in the future you can visit my profile