If it has to be ALL three conditions, then
=IF(AND(MAX(A1:A7)=D1,MIN(B1:B7)<=D2,(C1-C2)/E1=.10),result if true,
result if false)
"Shooter" wrote:
I am having trouble putting the following three conditions together in a
formula, each of the three conditions must be met:
1) if(or(A1:A7=D1)
2) if(or(B1:B7<=D2)
3) ((C1-C2)/E1=.10)
I have tried the following but it is not working:
=if(or(A1:A7=D1),if(or(B1:B7<=D2),((C1-C2)/E1=.10),G1,""))
I appreciate your help with this. Thanks.
--
Shooter
|