# help with simple formula

1. ## 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

3. ## RE: help with simple formula

try
=if(and(max(A1:A7)>=D1,Min(B1:B7)<=D2,(C1-C2)/E1>=0.1),G1,"")

"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

4. ## RE: help with simple formula

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

5. ## RE: help with simple formula

try
=if(and(max(A1:A7)>=D1,Min(B1:B7)<=D2,(C1-C2)/E1>=0.1),G1,"")

"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

6. ## RE: help with simple formula

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1