If Statement with Multiple Conditions

[abbeyrd237]

Hello,

I'm trying to find the best formula where it will return Column D (Name) if it meets all 3 conditions (Column A,B and C). For example, If Jan 2020 Too small, return Jane Doe. Also return a blank if false. Thank you!

Column A Column B Column C Column D
Jan 2020 Too small Jane Doe
Feb 2020 Too big John Doe
Mar 2019 Too small Jim Doe

 

[abbeyrd237]

Thank you so so much! The IF AND works perfectly!

 

[mikerickson]

=IF(A2="Jan", IF( B2=2020, IF( C2="Too Small", D2, "")))
This formula seems to work but it still returns FALSE if the condition isn't met. Not sure why it won't return a blank?

The outer IF statment is constructed like =IF(A2="Jan", [If True] ). Since it is missing the [if False] value it returns the value FALSE.

For that construction
=IF(A2="Jan", IF( B2=2020, IF( C2="Too Small", D2, "")), "")