IF AND / OR Equation

[usc1382]

Hello,

I am having issues with embedding AND / OR into my IF statements. I am taking a column and looking for a certain value and if it meets the value, I need to look at two cells to determine if it passes a test. I believe the answer is relatively simple and thanks for the help!! Please see the attachment as I have described this problem in detail


Thanks!

[arthurbr]

Try =IF(AND(B3=50,AND(D3<>"",E3<>"")),"ok","check")

[Cutter]

My interpretation would be

=IF(B3<>50,"",IF(LEN(D3)*LEN(E3),"OK","CHECK"))

[usc1382]

Thanks for the help!

[Cutter]

You're welcome. Thanks for the "scales tap".
Don't forget to mark your thread as SOLVED (see FAQ link at top of page for instructions if needed).