Sean15
Well-known Member
- Joined
- Jun 25, 2005
- Messages
- 698
- Office Version
- 2010
- Platform
- Windows
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
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