# Multiple Conditions

#### thesuggs76

##### Board Regular
Hi All
I have a number of fields that I'm trying to incorporate into an IIF statement and I was wondering if anyone could help.
I'm looking at RefferalDays, AppointmentDays, and Attended.
The criteria is ReferralDays <8, AppointmentDays<8, and Attended is either 1 or 0 depicting Attended or DNA
Thanks

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Any use?

Sheet1

 A B C D 1 Referral Day Appointment Days Attended 2 2 3 1 TRUE 3 8 9 1 FALSE 4 1 1 0 FALSE 5 1 1 1 TRUE 6 10 4 1 FALSE

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:102px;"><col style="width:130px;"><col style="width:95px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas
 Cell Formula D2 =IF(AND(A2<8,B2<8,C2=1),TRUE,FALSE) D3 =IF(AND(A3<8,B3<8,C3=1),TRUE,FALSE) D4 =IF(AND(A4<8,B4<8,C4=1),TRUE,FALSE) D5 =IF(AND(A5<8,B5<8,C5=1),TRUE,FALSE) D6 =IF(AND(A6<8,B6<8,C6=1),TRUE,FALSE)

<tbody>
</tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

AP

Any use?

Sheet1

 A B C D 1 Referral Day Appointment Days Attended 2 2 3 1 TRUE 3 8 9 1 FALSE 4 1 1 0 FALSE 5 1 1 1 TRUE 6 10 4 1 FALSE

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:102px;"><col style="width:130px;"><col style="width:95px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas
 Cell Formula D2 =IF(AND(A2<8,B2<8,C2=1),TRUE,FALSE) D3 =IF(AND(A3<8,B3<8,C3=1),TRUE,FALSE) D4 =IF(AND(A4<8,B4<8,C4=1),TRUE,FALSE) D5 =IF(AND(A5<8,B5<8,C5=1),TRUE,FALSE) D6 =IF(AND(A6<8,B6<8,C6=1),TRUE,FALSE)

<tbody>
</tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

AP

Thanks for replying however I'm using Access and not excel
Thanks

Apologies...must have been thrown of off the excel thread!

The criteria is ReferralDays <8, AppointmentDays<8, and Attended is either 1 or 0 depicting Attended or DNA
Can you explain last part a little more?
And what do you want returned if all of these conditions are met (or not)?

Replies
5
Views
178
Replies
9
Views
226
Replies
1
Views
702
Replies
5
Views
2K
Replies
11
Views
1K

Threads
1,203,242
Messages
6,054,343
Members
444,717
Latest member
melindanegron

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back