2 IF STATEMENTS WITH DIFFERENT VALUES.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to display a value only if one of these items is true. For
example -
IF(F6 =TRUE,"X",MONDAY!F5),IF(G6=TRUE,"Y",MONDAY!F5). The problem that I am
having is that it is displaying both fields and I only want it to display the
field that is true.
 
What if both are true, then what do you want it to do?

If you want to return Monday!F5 if neither are true OR both are false,
otherwise return X if F6 = TRUE or return Y if G6 = True then us
=IF(OR(AND(F6=TRUE,G6=TRUE),AND(F6=FALSE,G6=FALSE)),Monday!F5,IF(F6=TRUE,"X","Y"))
 
Back
Top