IF formula please help

[syed]

I am trying to work out the following formula and it wouldn't work.

The formula as follows:

=IF(B11>E11#AND#D11>D10,1,IF(C11<F11#AND#D11<D10,-1,G10))

Can someone please tell me what is it I am doing wrong on this formula.

Thank you for your help.

 

[Fred Smith]

The #AND# construct is not supported in Excel. You must be thinking of some
other programming language. With Excel, you use the And function:

=if(and(b11>e11,d11>d10),1,if(and(c11<f11,d11<d10),-1,g10))

 

[duane]

=IF(and(B11>E11,D11>D10),1,IF(and(C11<F11,D11<D10),-1,G10)