2 IF STATEMENTS WITH DIFFERENT VALUES.
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 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. |
All times are GMT +1. The time now is 12:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com