vipaman
asked on
'If' 'and' statement
I need to check the values of a number of cells and keeping getting errors. D39 is a 'list cell' to control entries
1st check
=IF(D37="No", And(D39="Sea"or"Country")" text1=iftr ue","text2 =iffalse")
if I then change cell D37 to 'Yes' then
=IF(D37="Yes", And(D39="Sea"or"Country")" text3=iftr ue","text4 =iffalse")
Thanks in advance Paul
1st check
=IF(D37="No", And(D39="Sea"or"Country")"
if I then change cell D37 to 'Yes' then
=IF(D37="Yes", And(D39="Sea"or"Country")"
Thanks in advance Paul
Can you upload sample and show expectd result?
I am not sure, where is your Text1, Text2, Text3 or Text4 are:
Try below:
Try below:
=IF(AND(D37="No",OR(D39="Sea",D39="Country")),"True","False")
ASKER
See attached file. Cell D41 ( titled - Determination of Peak Velocity Pressure) is what I am trying to populate with the output.
scaffoldv3.xlsx
scaffoldv3.xlsx
ASKER
Shums, logic is nearly there. I'll try and explain. When cell D37 = No and D39 = Sea or Country them D41= equation 1 if false then = equation 2.
If D37 = Yes and D39 = Town then D41 = equation 3
Hope that makes sense?
If D37 = Yes and D39 = Town then D41 = equation 3
Hope that makes sense?
Hi Paul,
Where is equation? I mean in which cells?
Where is equation? I mean in which cells?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I want the calc to be done in cell D41. Just got to deal with daughter for an hour.
Try below:
=IF(AND(D37="Yes",D39="Town"),"Equation3",IF(AND(D37="No",OR(D39="Sea",D39="Country")),"Equation1","Equation2"))
scaffoldv3.xlsx
ASKER
Excellent thanks chaps
Paul,
If any of our solution served your purpose, I would request you to please close the question.
Regards,
If any of our solution served your purpose, I would request you to please close the question.
Regards,
ASKER
A concise answer
Try changing D37 as Yes and D39 as Sea or Country, Accepted answer will result as "FALSE".