If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Zero values in a log chart | Joelle_Smith | Charts and Charting | 1 | December 23rd, 2004 07:58 PM |
How to calculate values from 2 tables | Luke | Running & Setting Up Queries | 2 | December 9th, 2004 03:55 PM |
average, eliminating zero values | Chris | Worksheet Functions | 6 | May 14th, 2004 11:36 PM |
Look up values in one column based on values in another without repeating | fbarbie | Worksheet Functions | 0 | April 8th, 2004 09:38 PM |
Conditional sum based on values in one or more columns | Mario | Worksheet Functions | 13 | December 23rd, 2003 09:38 PM |