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 use
=IF(OR(AND(F6=TRUE,G6=TRUE),AND(F6=FALSE,G6=FALSE) ),Monday!F5,IF(F6=TRUE,"X","Y"))

"Mindie" wrote:

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.