How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask The-PC-Guy Your Own Question

The-PC-Guy
The-PC-Guy, Computer Manager
Category: Computer
Satisfied Customers: 1952
Experience:  20 years experience providing remote computer support
62934938
Type Your Computer Question Here...
The-PC-Guy is online now

formula building on excel

Resolved Question:

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

My name is James

Welcome to Just Answer

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















































































































January 7,250.0042051478
February 7,250.00527705108
March 7,250.00733867132
April 7,250.00838988151
May 7,250.008421088166
June 7,250.009451169178
July 7,250.009471229188
August 7,250.00104912710196
September 7,250.00105113110202
October 7,250.00105213510207
November 7,250.00115313711211
December 7,250.00115413911214

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 2 years ago.
Thanks
let me send this to the programing section
Customer: replied 2 years ago.

Ok cool

Expert:  The-PC-Guy replied 2 years ago.
Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question

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

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

you could upload to

www.wikisend.com

after uploading they provide a file ID#

paste that number here
Customer: replied 2 years ago.

Hi Andrew,

I have highlighted the table

Thanks

http://wikisend.com/download/297380/Workbook1.xlsx

Expert:  The-PC-Guy replied 2 years ago.
give me a few to take a look at it
Expert:  The-PC-Guy replied 2 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 2 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 2 years ago.
let me know if this is what you are looking for

http://wikisend.com/download/747548/Workbook1-JA-Mod.xlsx

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

http://www.justanswer.com/computer/expert-1expert-2rulethemall/

and ask a question right in my box,

also you can put "PC Guy only" in your question title if you want to get to me.
The-PC-Guy, Computer Manager
Category: Computer
Satisfied Customers: 1952
Experience: 20 years experience providing remote computer support
The-PC-Guy and other Computer Specialists are ready to help you

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • Kamil Anwar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    161
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | Next >
  • http://ww2.justanswer.co.uk/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg Kamil Anwar's Avatar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    161
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.co.uk/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    93
    Technical Director of IT Company
  • http://ww2.justanswer.co.uk/uploads/JO/JonTech/2011-10-25_111835_A2c.64x64.jpg Jon-Tech's Avatar

    Jon-Tech

    IS Manager

    Satisfied Customers:

    61
    20 yrs: Computers, Networking
  • http://ww2.justanswer.co.uk/uploads/JA/jamieratliff/2012-2-8_194551_jamie.64x64.jpg jamieratliff's Avatar

    jamieratliff

    Information Systems Manager

    Satisfied Customers:

    21
    Jamie has worked in the Information Technology field for over a decade.
  • http://ww2.justanswer.co.uk/uploads/JA/JACUSTOMERleg4q7o8/2012-3-6_203036_meja.64x64.png TheDoctor's Avatar

    TheDoctor

    Software Engineer

    Satisfied Customers:

    16
    Experienced Software Engineer
  • http://ww2.justanswer.co.uk/uploads/FI/FisherEngineering/2012-1-18_194422_Fisher375Headshotcompressed239K.64x64.jpg Bill Fisher's Avatar

    Bill Fisher

    Computer Engineer

    Satisfied Customers:

    1
    Computer system design, networks, integration, general support.
  • http://ww2.justanswer.co.uk/uploads/ZE/zeyank/2014-12-9_221254_zeyank.64x64.png Ryan H.'s Avatar

    Ryan H.

    Computer Support Specialist

    Satisfied Customers:

    1739
    A+ Certified Technician - 10 Years experience working with all types of computer systems.