0

NP Formula with multiple if condition not work

Ahsanm M

August 22, 2019 06:38

None

Follow

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.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Bryan Robinson September 05, 2019 19:05

  Text in Excel for IF statements are case sensitive. Is the Job No. actually all caps?

  I built this in my demo database and it worked fine: =NP("Formula","if(AND([@[Amount]]=0,[@[Area Code]]=""""),1,0)") to say if the amount is zero and the area code is blank, then 1, else 0.