Excel - IF Function Problem - Expert Solution

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

I need an if/and formula which will allow me to say if a1 is 6 and a2 is 1 then put 150....I have that formula - =IF(AND(U329=6,AD329=1),150,"") But if a2 is 2 I need it to be 175 and if it is 3 I need it to be 200.
Solved by M. U. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 08/12/2017 - 04:41
Hi,
Excelchat Expert 08/12/2017 - 04:42
User 08/12/2017 - 04:44
Thank you
Excelchat Expert 08/12/2017 - 04:45
Ok. With fixed 6 value, you would like to change other values?
User 08/12/2017 - 04:45
Yes, I will show you...
Excelchat Expert 08/12/2017 - 04:47
=if(A2=6,if(B2=1,150,if(B2=2,175,if(B2=3,200,""))),"")
Excelchat Expert 08/12/2017 - 04:47
User 08/12/2017 - 04:47
Stop
User 08/12/2017 - 04:48
It brought back a blank
User 08/12/2017 - 04:49
Oh, Wait
User 08/12/2017 - 04:50
It works!!! Yay!!
Excelchat Expert 08/12/2017 - 04:50
What is the problem with the formula?
Excelchat Expert 08/12/2017 - 04:50
Great to hear
Excelchat Expert 08/12/2017 - 04:50
Thank you. Have a great day ahead:)
User 08/12/2017 - 04:50
You're awesome
Excelchat Expert 08/12/2017 - 04:50
Please visit Got It Pro for new queries.
User 08/12/2017 - 04:50
Saving this site!!!
Excelchat Expert 08/12/2017 - 04:51
Hi,
Excelchat Expert 08/12/2017 - 04:51
Please leave a great feedback after ending the session
User 08/12/2017 - 04:52
I will. Thank you again.

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.