IF function HELP

Formula:

=IF(AND(OR(A2="GOV",A2="Emb",A2="MNC"),OR(B2="waived",B2="partially waived",B2="fully paid")),"LOW","HIGH")

Or if you want to check for blank cells

Formula:

=IF(A2="","",IF(AND(OR(A2="GOV",A2="Emb",A2="MNC"),OR(B2="waived",B2="partially waived",B2="fully paid")),"LOW","HIGH"))

Originally Posted by PFDave

Formula:

=IF(AND(OR(A2="GOV",A2="Emb",A2="MNC"),OR(B2="waived",B2="partially waived",B2="fully paid")),"LOW","HIGH")

Or if you want to check for blank cells

Formula:

=IF(A2="","",IF(AND(OR(A2="GOV",A2="Emb",A2="MNC"),OR(B2="waived",B2="partially waived",B2="fully paid")),"LOW","HIGH"))

thanks for the support, it solved my problem