IF formula please help

S

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.
 
F

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))
 
Top