View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Multiple critera

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


Regards
FSt1

"Donna" wrote:

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