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.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask K Dismas Your Own Question
K Dismas
K Dismas, Computer Hardware Engineer
Category: Programming
Satisfied Customers: 9134
Experience:  Developer/Programmer/Computer Technician
104540271
Type Your Programming Question Here...
K Dismas is online now

I am looking for an equation that will leave a result of 300

Customer Question

I am looking for an equation that will leave a result of 300 if A1 is Thu or 250 if Sat or zero if none of these
JA: Is there a specific language you're coding in?
Customer: I was hoping to use excel
JA: What application are you using?
Customer: MS Excel 2007
JA: Have you installed any updates recently?
Customer: about 3 daays ago
JA: Anything else you want the Microsoft Office Expert to know before I connect you?
Customer: That's it thanks
Submitted: 7 days ago.
Category: Programming
Expert:  K Dismas replied 7 days ago.

Hi, welcome to JustAnswer! My name is***** am sorry for the trouble you are facing right now. But, I'll do my best to help you with your concern.

May I know what trouble you are experiencing?

Customer: replied 7 days ago.
I am trying to leave a cell with one of three values. If Cell A1 = "Thu" then 300, or if A1 = "Sat" then 250 else 0. Is there a way to do this in excel do you think?
Expert:  K Dismas replied 7 days ago.

I'm sorry this has happened. I will provide you with information to help you fix the problem.

  • You can use the IF function in excel.

  • You can use the formula in the excel cell below.

    • =IF(A1="Thu",300,IF(A1="Sat",250,0))

Also, please let me know if you have questions so I can assist you furthermore.

Customer: replied 7 days ago.
The "Thu" one is now giving the result of 300, but the "Sat" one is still showing 0
Customer: replied 7 days ago.
It's OK now, I hadn't changed the cell numbers. Thanks for your help, it has been annoying me.
Expert:  K Dismas replied 7 days ago.

I'm glad it's ok now. You're welcome. Stay safe and have a wonderful day.

Expert:  K Dismas replied 5 days ago.

Hi, it's me, Kent. I'm just checking by. I hope everything is okay. I will now close this question. Stay safe and have a great day.