IF AND Statement

I'm trying to write and IF and Statement: IIf (Balance 12.31.2018=0 AND Balance 6.30.2018<>0, "New", "No") but it gives me an error. I'm trying to say that as long as my 12/31 balance is 0 and my 6/30 balance is anything other than 0 to return "New". Any help would be greatly appreciated!

Expression

Accepted answers

I think you're probably getting the operator wrong.

IIf (Balance 12.31.2018=0 AND Balance 6.30.2018!=0, "New", "No")

Use != instead of <>

Also, check for datatypes.

Cheers,

All comments

What error do you get?

Your statement looks good but without more information its hard to diagnose

I think you're probably getting the operator wrong.

IIf (Balance 12.31.2018=0 AND Balance 6.30.2018!=0, "New", "No")

Use != instead of <>

Also, check for datatypes.

Cheers,

It says "An expression cannot end with an operator" I'm guessing it doesn't like the <> but not sure how to fix it?

Thanks so much! Works perfect!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703