How JustAnswer Works:
• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee
Ask Jason Jones Your Own Question
Jason Jones, Programmer
Category: Programming
Satisfied Customers: 15671
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
Submitted: 1 year ago.
Category: Programming
Expert:  Jason Jones replied 1 year ago.
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
Expert:  Jason Jones replied 1 year ago.
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"
Expert:  Jason Jones replied 1 year ago.
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!"
Expert:  Jason Jones replied 1 year ago.
May I ask if that worked or not?