campos1578
New Member
 Joined
 Jan 3, 2020
 Messages
 12
 Office Version

 2019
 Platform

 MacOS
Hey Team,
I have set up conditional true/false criteria for evaluating if something will fit (Max dimensions allowable are shown in color). In my example below, I've taken the first line item on the left and and kept the weight but evaluated the other dimensions (width,height,length) in different orders to see if they will fit. I want the cell next to "Will it Fit" (Q6) to display "Yes" if all dimensions = "True" from Q3,Q4,Q5 or "False" if even one dimension criteria in Q3,Q4,Q5 = "False".
Formula for "True"/"False" value: =IF(AND(M2<=3.9, N2<=9.7,O2<=5.8, P2<=9.7), "True","False")
Question 1  How do I get Q6 to evaluate the aforementioned criteria and display "Yes" or "No"?
Question 2  How can I automate this process for the rest of my lines?
Thanks for the help!
Jonathan
I have set up conditional true/false criteria for evaluating if something will fit (Max dimensions allowable are shown in color). In my example below, I've taken the first line item on the left and and kept the weight but evaluated the other dimensions (width,height,length) in different orders to see if they will fit. I want the cell next to "Will it Fit" (Q6) to display "Yes" if all dimensions = "True" from Q3,Q4,Q5 or "False" if even one dimension criteria in Q3,Q4,Q5 = "False".
Formula for "True"/"False" value: =IF(AND(M2<=3.9, N2<=9.7,O2<=5.8, P2<=9.7), "True","False")
Question 1  How do I get Q6 to evaluate the aforementioned criteria and display "Yes" or "No"?
Question 2  How can I automate this process for the rest of my lines?
Thanks for the help!
Jonathan