Computer
Ask a Computer Question, Get an Answer ASAP!
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
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)
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.
Attachment: 2014-11-24_105645_quadrant_analysis_quest.xlsx
amended and more explicit to hopefully give maximum flexibility and avoid any doubt
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!
Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question http://ge.tt/60vFrA52/v/0?cIt 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 concernsPLEASE DON'T FORGET TO RATE SO I AM PAID FOR MY TIMEIT WILL NOT COST ANYTHING ADDITIONAL BEYOND THE VALUE OF YOUR QUESTIONTO RATE, CLICK THE SMILEY FACES BENEATH THIS ANSWERDo 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 profilehttp://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.
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!