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 Steve Herrod Your Own Question

Steve Herrod
Steve Herrod, Computer Support Specialist
Category: Software
Satisfied Customers: 160
Experience:  Familiar with a wide variety of software and experienced in user training/support
65126503
Type Your Software Question Here...
Steve Herrod is online now

I need to rearrange an equation in MS Excel

Customer Question

I need to rearrange an equation in MS Excel
Submitted: 6 months ago.
Category: Software
Expert:  Jason Jones replied 6 months ago.

Hello,

I am the person that will be helping you today.

How may I help you today?

I will be standing by, looking forward to your response.

Thank you,
Jason

Customer: replied 6 months ago.
I need to rearrange an equation in MS Excel. This is a math question really. I need to send the spreadsheet before I can explain what I want to do.
Expert:  Jason Jones replied 6 months ago.

Please, upload the document.

Please, be forewarned that the site is not secure:
- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Customer: replied 6 months ago.
Hello there. File ID number is ***** Please see the file, which is an MS Excel file. This is an extract of a vast database, but I have removed all but the information you need. At the moment, cell R19 is an output field, calculated using C19 and all the other information. So, if I enter 380 into C19, the result in R19 is 14. If I enter 370 into C19, the result in R19 is 22. What I need is for R19 to be an INPUT field, and C19 to be an output field. So, in other words, I can enter any number in R19 and the result appears in C19. As I said, this is really about mathematical equations, not IT. Thank you
Expert:  Jason Jones replied 6 months ago.

I have looked over the document and understand the question.

What is the process that you wish for me to code in the formula?

Customer: replied 6 months ago.
I am sorry, I don't understand your question. I want to be able to enter a figure in R19 and the result appear in C19 rather than the other way round, so what I need is the correct formula to use in cell C19. Thank you.
Customer: replied 6 months ago.
I am in the UK and it is 1.10am so I am going offline now and will review your answer or further queries tomorrow (Sunday). Thank you.
Expert:  Jason Jones replied 6 months ago.

The value of R14 is the some of some items and subtraction of other items. How is the number 380 related to this? It is a math problem. Please, give me the math.

Customer: replied 6 months ago.
I am sorry, I don't think we are going to get anywhere with this. The math is all right there in the spreadsheet. Thank you for trying.

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:

 
 
 
  • Steve Herrod

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    160
    Familiar with a wide variety of software and experienced in user training/support
< Last | Next >
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    160
    Familiar with a wide variety of software and experienced in user training/support
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    114
    Certified Software expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    112
    Computer Software Support specialist for more that 10 years
  • http://ww2.justanswer.com/uploads/FS/fszcze/2012-6-18_181848_500test.64x64.jpg Frederick S's Avatar

    Frederick S

    Computer Specialist

    Satisfied Customers:

    91
    Computer technician; founder of a home PC repair company.
  • http://ww2.justanswer.com/uploads/WA/wa94sound/2012-6-6_202633_iStock000007010121Small.64x64.jpg Bernie's Avatar

    Bernie

    Software Support

    Satisfied Customers:

    52
    6+ years experience, Microsoft MCDST/CompTia A+ Certified
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Software Engineer

    Satisfied Customers:

    38
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/jnayes/2010-12-23_132454_japicbetter.jpg jnayes's Avatar

    jnayes

    Computer Support

    Satisfied Customers:

    37
    Network Administrator
 
 
 

Related Software Questions