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.