2 IF STATEMENTS WITH DIFFERENT VALUES.

[Mindie]

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.

 

[Nick B]

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"))