Multiple Conditions

[thesuggs76]

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

 

[ArthriticPanda]

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

 

[thesuggs76]

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

 

[ArthriticPanda]

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

 

[Joe4]

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)?