IF Formula with AND added (I think)

[Mark D]

Morning all, desperately after some help if possible.

I have tried doing the following calculation but to no avail.


=SUMPRODUCT($B$8=1)*($F$15=1)*AND(IF(G11>D56,F11*B27,0))

What I am trying to say is as follows

If B8=1 and F15=1 and if G11 is greater than D56 take F11 and * by B27, if
not put 0.

But all I am getting is #value

Can anybody please help me

Thank you in advance

 

[Jacob Skaria]

Try the below

=IF(AND(B8=1,F15=1,G11>D56),F11*B27,0)

If this post helps click Yes

 

[Mujeeb ur Rehman, FBL-GRW-PK]

You may try the following

=if(and(B8=1,F15=1,G11>D56),F11*B27,0)

Mujeeb

 

[Mark D]

Excellent

Thank you both, both examples worked perfectly.