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
IIt's pleasure to help you today:)
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
Please refer the formulas.
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.