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: Microsoft Office
Satisfied Customers: 1842
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

I'd like to to assign multiple text to translate into

Customer Question

Hi. I'd like to to assign multiple text to translate into certain numbers using the IF command, but I'm getting errors. For example: "Leased" becomes 175. "Non Prod" becomes 24. And everything else becomes 189. Thanks!
Submitted: 11 months ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 11 months ago.

that syntax actuallly looks correct to me.

Can you explain the nature of your problem?

Expert:  The-PC-Guy replied 11 months ago.

i have not heard a response from you