NP Formula with multiple if condition not work

Hi All,

I have faced an issue while trying to add multiple conditions inside IF is not working

=NP("Formula","=IF(AND([@[Job Task No.]]=1,[@[Job No.]]=""TIME AWAY""),1,0)")

If I have only one condition if works. But when put AND with multiple conditions is not working.

Thanks in Advance.

1 comment

Please sign in to leave a comment.