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 Jason Jones Your Own Question

Jason Jones, Programmer

Category: Programming

Satisfied Customers: 15225

Experience: Over 10 years of work experience.

30759776

Type Your Programming Question Here...

Jason Jones is online now

I want to assign values to cells based upon user input. If

Customer Question

I want to assign values to cells based upon user input. If A,1 = 1 then B,1="Strongly Disagree" and C,1 = 0 If A,1 = 2 then B,1="Disagree" and C,1 = 0.25 If A,1 = 3 then B,1="Neutral" and C,1 = 0.5 If A,1 = 4 then B,1="Agree" and C,1 = 0.75 If A,1 = 5 then B,1="Strongly Agree" and C,1 = 1

Hello,I am the person that will be helping you today.Are you using a PC or a Mac?I will be standing by, looking forward to your response.Thank you,Jason

Please, upload the document so that I can set this up for you correctly. Once finished, I will upload it back to you. You can upload it on this page by clicking the Paperclip icon or by following the instructions below. 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"

Put the following formula in B1:=IF(A1=1,"Strongly Disagree",IF(A1=2,"Disagree",IF(A1=3,"Neutral",IF(A1=4,"Agree",IF(A1=5,"Strongly Agree",""))))) Put the following formula in C1:=IF(A1=1,0,IF(A1=2,0.25,IF(A1=3,".5",IF(A1=4,0.75,IF(A1=5,1,""))))) That will give you want you need. I look forward to hearing your feedback concerning whether or not your problem is fixed.I hope to hear back that all is working. If this is so, please do not forget to rate my help on the top of this page (choose the number of stars and click the Submit button). If it is not, please respond below.I will be standing by,Jason If you wish to work with me in the future for new problems, you can request to work with me either by posting the question on my profile page or by prefacing your question with, "For ***** ***** Only!"