If formula error

Hi Anonymous ,

There is no need of applying the AND operation twice by adding 'AND' & '&&'.

Try removing one, something like:

Margin Range =
IF (
    [NetMargin] <= .1,
    "<10%",
    IF (
        
            [NetMargin] >= .10
                && [NetMargin] <= .2,
            "10-20%"
        ,
        IF (
            
                [NetMargin] >= .2
                    && [NetMargin] <= .4,
                "20-40%"
            ,
            ">40%"
        )
    )
)

Also, looking at your requirement, I would suggest using a Switch statement here which would look something like this:

Margin Range =
SWITCH (
    TRUE (),
    [NetMargin] <= 0.1, "<10%",
    AND ( [NetMargin] >= .10, [NetMargin] ) <= .2, "10-20%",
    AND ( [NetMargin] >= .2, [NetMargin] ) <= .4, "20-40%",
    ">40%"
)

I hope this helps