Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need help with making an IF function with 3 possible answers
Solved by T. C. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/03/2018 - 10:52
Hello there, thanks for choosing Got It Pro - Excel.
Excelchat Expert 02/03/2018 - 10:53
Can you please tell us what do you want to achieve with a formula ?
User 02/03/2018 - 10:53
if they type W then it needs to show 30, if they type T then it needs to show 15, and if they type L then it needs to show a 0. Is this possible?
Excelchat Expert 02/03/2018 - 10:55
Yes, please wait a moment to create a formula for you.
User 02/03/2018 - 10:55
thank you
Excelchat Expert 02/03/2018 - 10:58
Can you please check on B3, B4 and B5 cell ?
Excelchat Expert 02/03/2018 - 11:01
Is this what you are looking for ?
User 02/03/2018 - 11:01
I copied it into my excel and changed the cell number but it isn't posting a result in the cell
Excelchat Expert 02/03/2018 - 11:02
Are you referring to the cells you have the letters ?
User 02/03/2018 - 11:03
nevermind, I was entering it incorrectly.
Excelchat Expert 02/03/2018 - 11:03
So is working well for you ?
User 02/03/2018 - 11:04
one last thing, is there a way to set a cell from not auto filling previos text used in another cell?
User 02/03/2018 - 11:04
the formula is working, I appreciate it very much
Excelchat Expert 02/03/2018 - 11:05
Okay great.
Excelchat Expert 02/03/2018 - 11:05
Can you please explain more what is your request ?
User 02/03/2018 - 11:06
when typing in cells, if the program recognizes a portion of the text, it will "autofill" the cell. is there a way to turn that off?
Excelchat Expert 02/03/2018 - 11:07
Click File > Options then Click Advanced, and then under Editing options, select or clear the Enable AutoComplete for cell values check box to turn this option on or off.
User 02/03/2018 - 11:08
thank you very much. you were a big help.
Excelchat Expert 02/03/2018 - 11:08
Our pleasure.
Excelchat Expert 02/03/2018 - 11:08
Thanks for choosing us.
Excelchat Expert 02/03/2018 - 11:08
Please give your kind feedback for our service.
Excelchat Expert 02/03/2018 - 11:09
If you need our please visit us again :)
Excelchat Expert 02/03/2018 - 11:09
Bye, have a good day ahead.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc