help with simple formula

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
Excluding Repeating Numbers Help!1 5
Baffeling IF statement 7
gain-loss 5
convert columns to rows 4
Simple calculation where values change to letters? 3
Combining several cells into single equasion? 1
Count...Sum...Faster...improvemens...; Have a good end of YEAR 2

Top