Nested IF Statement with Multiple Criteria

**Hoopsah** · 07-23-2007, 08:31 AM

Hi,

I am working n a spreadsheet that has 3 columns of data and I want to put in an IF Statement. e.g.

Column 1 Column 2 Column 3
True False False
False True False

In a new cell (C4) I want to display the outcome of the following:

If C1 = TRUE, then "Statement" or If C2 = True then "Statement" or If C3 = True then Statement else ""

Each time I try I get a response for the first IF but nothing else.

**oldchippy** · 07-23-2007, 08:37 AM

Try this,

=IF(C3=TRUE,"Statement else",IF(OR(C1=TRUE,C2=TRUE),"Statement",""))

**Hoopsah** · 07-23-2007, 09:21 AM

Sorry Oldchippy, don't think I explained it properly - Let me try again

Appointment Unannounced Pre Meeting
True False False - Row 1
False True False - Row 2
False False True - Row 3

If one column reads true then the other 2 will be false.

Row 1 should give the answer "Appointment"
Row 2 should give the answer "Unannounced"
Row 3 will give the answer "Pre Meeting"

Hope this is a bit clearer - Thanks Mate

**oldchippy** · 07-23-2007, 09:34 AM

Try this, with your heading in A1:C1

=IF(A2=TRUE,$A$1,IF(B2=TRUE,$B$1,IF(C2=TRUE,$C$1))) then drag down

**Hoopsah** · 07-23-2007, 09:44 AM

Magic!!!!

Thanks OldChippy, works perfectly.

Thanks again

**oldchippy** · 07-23-2007, 09:45 AM

Got there in the end - thanks for the feedback

Try this just in case you have no TRUES, it will then put a blank

=IF(A2=TRUE,$A$1,IF(B2=TRUE,$B$1,IF(C2=TRUE,$C$1,"")))