How to use an Iif Stament in an Expresion

Question

3.40/5 (2 votes)

See more:

Hi guys I have this line of code in c#
I keep getting this error=>
Syntax error: Missing operand before '&' operator.
Find below is my code thanks for any advice

C#

< ds.Tables[0].Columns.Add("RESULTS").Expression = "Iif(((ActualWeight >= (.96 * TargetWeight)) And (ActualWeight <= (1.04 * TargetWeight))),'GOOD',And (ActualWeight < (0.96 * TargetWeight))),'BAD', And (ActualWeight > (1.04 * TargetWeight))) 'BAD',null)";/pre>

Posted 30-Mar-15 3:28am

Ekona_Pikin

Updated 30-Mar-15 4:18am

v5

Add a Solution

Comments

Maciej Los 30-Mar-15 9:58am

Check the number of opening brackets ;)
="Iif((condition1) AND (condition2), resultiftrue, resultiffalse)";

Richard MacCutchan 30-Mar-15 10:20am

Your statement has too many commas and AND clauses; see Maciej's comment above.

CHill60 30-Mar-15 10:21am

There is at least a comma missing before that final 'BAD' but as Maciej has pointed out - the brackets don't match either

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mark Farmiloe · Accepted Answer · 2015-03-30T04:09:00

Solution 1

I think the dataset formula uses VBA so you should be using AND rather than &&.

Try

Iif((ActualWeight >= (.96 * TargetWeight)) And (ActualWeight <= (1.04 * TargetWeight)),'GOOD','BAD')

Posted 30-Mar-15 4:09am

Mark Farmiloe

Updated 30-Mar-15 4:32am

v2

Comments

Ekona_Pikin 30-Mar-15 10:51am

Thanks for all your help anyone who posted or try solve this problem I have tested both solution 2 and 3 and they are all on point :)) So for future reference The authors of both solutions 2 and 3 are RIGHT.

Mark Farmiloe 30-Mar-15 11:31am

I'm feeling unappreciated. :-(
My first answer was the correct answer to your first question and my extended answer removed all the extra unneeded code you added when you edited your first question.
Could you at least accept all three solutions worked for you?

Ekona_Pikin 30-Mar-15 11:38am

Hello Mark sorry I did not test ,but just did now and is on point too sorry sir :))

Mark Farmiloe 30-Mar-15 12:29pm

:-)

Richard Deeming · Accepted Answer · 2015-03-30T04:25:00

Looks like you want nested Iif statements. Try:

Iif(((ActualWeight >= (.96 * TargetWeight)) And (ActualWeight <= (1.04 * TargetWeight))), 'GOOD', Iif(ActualWeight < (0.96 * TargetWeight), 'BAD', Iif(ActualWeight > (1.04 * TargetWeight), 'BAD', null)))

Putting the expression on multiple lines might make things clearer:

Iif(
    ((ActualWeight >= (.96 * TargetWeight)) And (ActualWeight <= (1.04 * TargetWeight))), 
    'GOOD', 
    Iif(
        ActualWeight < (0.96 * TargetWeight), 
        'BAD', 
        Iif(
            ActualWeight > (1.04 * TargetWeight), 
            'BAD', 
            null
        )
    )
)

EDIT: As Maciej Los pointed out, you can simplify the formula so that you don't need nested Iifs. See solution #3 for details.

Maciej Los · Accepted Answer · 2015-03-30T04:29:00

Solution 3

Please, see my comment to the question.
I guess you have to define formula ths way:

VB

="Iif((ActualWeight > .96 * TargetWeight) And (ActualWeight <= 1.04 * TargetWeight),'Good','Bad');

There is no need to define nested iif's. If ActualWeight is Bigger Then ... and LessOrEqual then ... - then condition is true, else false.

Posted 30-Mar-15 4:29am

Maciej Los

Updated 30-Mar-15 4:34am

v2

Comments

Richard Deeming 30-Mar-15 10:34am

You've missed part of the formula at the start:
Iif(ActualWeight >= (.96 * ...

Maciej Los 30-Mar-15 10:35am

Corrected ;)
Thank you for pointing that ;)

Ekona_Pikin 30-Mar-15 10:35am

Maciej, what about the other conditions?

Maciej Los 30-Mar-15 10:36am

See updated answer. Not needed ;)

Ekona_Pikin 30-Mar-15 10:42am

Thanks Maciej:))

Maciej Los 30-Mar-15 13:39pm

You're very welcome ;)

How to use an Iif Stament in an Expresion

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us