Excel_Illerate
New Member
- Joined
- Jun 28, 2011
- Messages
- 14
Hello all,
I'm having a problem getting the multiple criteria to work in the below formula.
<table border="0" cellpadding="0" cellspacing="0" width="64"><col width="64"><tbody><tr height="20"> <td class="xl63" style="height: 15pt; width: 48pt;" width="64" height="20">
</td></tr></tbody></table><table style="width: 401px; height: 172px;" border="0" cellpadding="0" cellspacing="0"><col width="64"><tbody><tr height="20"> <td class="xl65" style="height: 15pt; width: 48pt;" width="64" height="20"> =DMAX($DRAW_Table,"DRAW",DRAW<=IF(C11=0,$D$3,C11) AND (FIRST=C$9 OR SECOND=C$9 OR THIRD=C$9 OR FOURTH=C$9 OR FIFTH=C$9)))
I displayed it above with colors as it's in the cell.
DRAW_Table has 6 columns consisting of Draw, First, Second, Third , Fourth, and Fifth.
I read the Help files about using the "AND" and "OR" within criteria, but it doesn't seem to want to work.
Would someone take a look at this and please tell me what I'm doing wrong?
Thank you ahead of time.
</td> </tr></tbody></table>
I'm having a problem getting the multiple criteria to work in the below formula.
<table border="0" cellpadding="0" cellspacing="0" width="64"><col width="64"><tbody><tr height="20"> <td class="xl63" style="height: 15pt; width: 48pt;" width="64" height="20">
</td></tr></tbody></table><table style="width: 401px; height: 172px;" border="0" cellpadding="0" cellspacing="0"><col width="64"><tbody><tr height="20"> <td class="xl65" style="height: 15pt; width: 48pt;" width="64" height="20"> =DMAX($DRAW_Table,"DRAW",DRAW<=IF(C11=0,$D$3,C11) AND (FIRST=C$9 OR SECOND=C$9 OR THIRD=C$9 OR FOURTH=C$9 OR FIFTH=C$9)))
I displayed it above with colors as it's in the cell.
DRAW_Table has 6 columns consisting of Draw, First, Second, Third , Fourth, and Fifth.
I read the Help files about using the "AND" and "OR" within criteria, but it doesn't seem to want to work.
Would someone take a look at this and please tell me what I'm doing wrong?
Thank you ahead of time.
</td> </tr></tbody></table>