IF Formula with AND added (I think)
 

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(G11D56,F11*B 27,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

IF Formula with AND added (I think)
 

Try the below

=IF(AND(B8=1,F15=1,G11D56),F11*B27,0)

If this post helps click Yes
---------------
Jacob Skaria


"Mark D" wrote:

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(G11D56,F11*B 27,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

IF Formula with AND added (I think)
 

You may try the following

=if(and(B8=1,F15=1,G11D56),F11*B27,0)

Mujeeb


"Mark D" wrote:

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(G11D56,F11*B 27,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

IF Formula with AND added (I think)
 

Excellent

Thank you both, both examples worked perfectly.

"Mujeeb ur Rehman, FBL-GRW-PK" wrote:

You may try the following

=if(and(B8=1,F15=1,G11D56),F11*B27,0)

Mujeeb


"Mark D" wrote:

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(G11D56,F11*B 27,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