IF Formula with AND added (I think)

  • Thread starter Thread starter Mark D
  • Start date Start date
M

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
 
Try the below

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

If this post helps click Yes
 
You may try the following

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

Mujeeb
 
Back
Top