Multiple if for checking conditions

[vpanchuda]

Compliance	Approvalindicator	Approval date
N/A	Yes
N/A	Yes
N/A	NO	01-01-2019
N/A	NO
N/A	NO

IF(Compliance='N/A' AND ApprovalIndicator='true','Approved N/A',
iF(Compliance='N/A'AND ApprovalIndicator='false','Not Approved N/A',


Compliance))) as CalculatedCompliance,

In the above table, I have coded the above syntax and works fine, I also have to add one more if in the same loop for the below condition, not able to get the syntax.

iF(Compliance='N/A' AND ApprovalIndicator='false',  and [here i have to check if anything  is entered in this cell it can be date or any string in Approvaldate field  ) 'Approved N/A',

Can anyone help me with syntax, please?? ie

if Compliance =N/A and

ApprovalID=NO and

if any value is present in the Approval date column then it should return 'Approved N/A' (this could be number or string in the cell)

[micheledenardi]

Maybe:

iF(Compliance='N/A' AND Approvalindicator='NO' AND len(trim(ApprovalDate))>0,'Approved N/A','Not Approved N/A')