| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Save External Link Values | Excel Discussion (Misc queries) | |||
| 2 If Statements between 2 values Q | Excel Worksheet Functions | |||
Linear Mode
