IF AND

Hi,

I'm trying to insert a formula which can lookup if it is null in 2 fields for the same row/record and if it is then output "No" else output "Yes" --> IIF(IsNull([Field 1]) AND (IsNull([Field 2]),"No","Yes")

The error I keep receive is "Malformed If statement".

Any help is appreciated - thanks.

Preparation

Expression

Accepted answers

MarqueeCrew

Looks reasonable, but try

IIF(isnull([field1]) && isnull([field 2]),"No","Yes")

MarqueeCrew

Great. If you wouldn't mind, could you mark that as solved?

thanks,

mark

All comments

MarqueeCrew

Looks reasonable, but try

IIF(isnull([field1]) && isnull([field 2]),"No","Yes")

It worked perfectly! Thank you for that

papalow

Thanks for posting this, can you use && in a regular IF THEN ELSE ?

Matt_Sinker

Hi There,

Taking the same logic, how would I go about writing a formula with 3 conditions.

I am trying to replicate an excel formula which would read:

=IF(AND([X]="Y",[X]="N",[X]="N"),"Y","N")

Tried using the IF ELSEIF function but this isn't right, any thoughts?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703