Multiple if for checking conditions

vpanchuda — Sat, 16 Nov 2024 05:40:50 GMT

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)

Re: Multiple if for checking conditions

micheledenardi — Mon, 03 Jun 2019 12:42:08 GMT

Maybe:

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

topic Re: Multiple if for checking conditions in App Development

Multiple if for checking conditions

Re: Multiple if for checking conditions