Multiple critera

[Donna]

Hi, I need help with a formula for the following:

If Column E =7 and Column F = 7 and column G = F it can return a value of
True if not False

Thanks Donna

 

[FSt1]

hi
try this....
=IF(AND(E2=7,F2=7,G2="F"),TRUE,FALSE)


Regards
FSt1

 

[Donna]

Thank you very much
Donna

hi
try this....
=IF(AND(E2=7,F2=7,G2="F"),TRUE,FALSE)


Regards
FSt1