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: 1949
Experience:  20 years experience providing remote computer support
62934938
Type Your Computer Question Here...
The-PC-Guy is online now

i need someone to write an excel formula for me, essentially

Resolved Question:

i need someone to write an excel formula for me, essentially a "nested IF AND" formula
Submitted: 2 years ago.
Category: Computer
Expert:  Jess M. replied 2 years ago.
Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

Can you please send me a sample or Dummy Excel file where you want the formulas to be entered so that I can directly work on it here in my computer? If this is possible, you can attach the Excel file using the paper clip icon in the reply box. It is intended for pictures but it will also work with Excel files.

Please let me know so that I can help you further.

Best regards,
Jess
Customer: replied 2 years ago.

I will attach the spreadsheet. formula data is takenm from "sheet1", instructions regarding the formula are in "instructions". If you require further clarification, please call +44 7557 360922

Expert:  Jess M. replied 2 years ago.
Hi,

Thank you for the sample file. Please give me a moment to work on this. I will send you the modified later.

Best regards,
Jess
Expert:  Jess M. replied 2 years ago.
Hi,

Let me summarize the requirements:

IF BW=Value Creator and CB = Increasing, and CL = growing, either CM is faster or slower, CP will display Compounder.

IF BW=Value Creator and CB = Increasing, and CL = shrinking, either CM is faster or slower, CP will display Falling Angel.

IF BW=Value Creator and CB = Decreasing, and CL = growing, either CM is faster or slower, CP will display Compounder.

IF BW=Value Creator and CB = Decreasing, and CL = shrinking, either CM is faster or slower, CP will display Falling Angel.

IF BW=Value Destroyer and CL = growing, IF CM is faster, CP = PROBLEM. If CM = Slower, then CP = Rising Star.

IF BW=Value Destroyer and CL = shrinking, IF CM is faster or slower, CP = Rising Star.

Is that correct?
Customer: replied 2 years ago.

that is almost correct, but there should be the same iterations for BW = value destroyer as there were for BW = value creator ( i did not put all the arrows in - my mistake)

Expert:  Jess M. replied 2 years ago.
Hi,

Thank you for writing back. Can you please clarify that Value Destroyer options?
Customer: replied 2 years ago.

ok let me re-work it to be 100% sure. I will change the answers a little bit to ensure that the formula allows for flexibility.

Expert:  Jess M. replied 2 years ago.
Yes, please take your time.

Thanks.
Jess
Customer: replied 2 years ago.

Attachment: 2014-11-24_105645_quadrant_analysis_quest.xlsx

amended and more explicit to hopefully give maximum flexibility and avoid any doubt

Expert:  Jess M. replied 2 years ago.
Thanks for the detailed information. This is a complex requirement, please give me so time to build your formula for this.

Regards,
Jess
Customer: replied 2 years ago.

I appreciate that this may have cost more than the price which was quoted so if you need to revise the price, that is not a problem, just let me know!

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

Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question

http://ge.tt/60vFrA52/v/0?c

It seams you have been waiting for an answer so I took the liberty of answering this for you.

It was best to use a lookup table as opposed to 16 nested ifs. You will see the formula in cell CP7, I assume that you wanted it in that column, but if you need to move it to a different column let me know and I will tell you how to do it.

also if you wish to change the values displayed, all you simply need to do is modify the values in column E on sheet 2
---------------------------------------------------------------------------------------------------------------

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.

Customer: replied 2 years ago.

wow that was fanastic. I have never used a lookup table before, that makes it so much easier and will vasty improve my quality of life! Thank you very much for your help. Brilliant!

Expert:  The-PC-Guy replied 2 years ago.
your welcome

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
The-PC-Guy, Computer Manager
Category: Computer
Satisfied Customers: 1949
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.