Help with AND formula

[Sean15]

Hi:
Formula below is returning FALSE. Required value is to add N16 and X16 if A16 is equal to 1 and B16 is equal to "DF". If not return 0.
=IF(AND(A16=1,B16="DF",N16+X16),0)

Could you help please?

Regards,
Sean

 

[Joe4]

You put a parenthesis in the wrong place, leaving no FALSE clause in your formula (which would just default FALSE entries to "FALSE").
(You put "N16+X16" in your AND clause, instead of in the TRUE clause).

Try:

=IF(AND(A16=1,B16="DF"),N16+X16,0)

 

[Sean15]

Thank you very much.

Regards,
Sean

 

[Joe4]

You are welcome.