IF formula please help

G

Guest

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

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

Help with Formula 3
Problem with >= in function 4
Payment calculation 1
Stripe out duplicate data 5
Excel if Functions 1
< > question for multiply cells. 2
formula help 4
strange conditional format behavior 5

Top