help with simple formula
 

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

http://www.excelforum.com/showthread.php?t=380105
http://www.excelforum.com/showthread.php?t=380106


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=380109