combining 2 if formulae

[anilpatni1234]

Hey guys,

I need help with simple problem,

I need to combine 2 "if" formulae together.

I guess i need to use AND formulae here


If sheet "PRODUCT" , range "T" is equal to "NO" AND
If sheet "PRODUCT", range "Q" is greater than 360 but less than 800

Is these 2 statement is true then it must show true.

I know how to do but i am not able to crack the 2nd condition

[AliGW]

Try this:

=AND(T1,"NO",Q1,>360,Q1,<800)

As you are looking for a TRUE/FALSE outcome, you don't actually need an IF statement at all - the above will evaluate to TRUE or FALSE.

[Glenn Kennedy]

Maybe:

=IF(AND(Q2>360,Q2<800,T2="Yes"),"TRUE","")

Ali's right. IF not needed and I got my Yes and No the wrong way round. Need coffee.

[anilpatni1234]

Hey Ali,
thanks,

I knew that AND would perfectly help me but I was not able to implement it.

But the formulae which you provided me is not working .

I have attached the sample.

Could you please have a look.

[AliGW]

Try this:

=AND([@[stock in hand]]="NO",[@Column3]>360,[@Column3]<800)

[anilpatni1234]

Hey Ali,

Great .

Thank you .

It works now.

Also just to update you - I am trying a different way to work on my project.

Hope it works

[AliGW]

Great!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.