IF AND formulas not working

[Anonymous]

Autodesk,

I have created an IF/AND formula with 3 "AND"s. I get an "improper use of boolean expressions" error. But I noticed it works with 2 "AND"s. Is 2 my limit? Or is there a work around to add more than 2? I tried the "3 AND" formula in Excel and it worked like a charm.

Here is my formula that does not work (3 ANDs): "if(and(Phase Multiplier = 1, FAN VOLT = 120 V, FAN HP=1), 16 A, 0 A)"

Here is my formula that does work (2 ANDs): "if(and(Phase Multiplier = 1, FAN VOLT = 120 V), 16 A, 0 A)"

Get your best programmer on this!!!!!

Thanks!

[Chris.Aquino]

At this time it looks like AND conditional statements are meant for 2 True statements. If you wan to have more than 2, I would look at using nested IF Conditional Statements.

The following section from the Help has more information:

Conditional Statements

[CoreyDaun · Accepted solution]

You CAN have more than one condition for the AND function, I've been using that for quite a long time. I think the error may lie with "FAN HP". Try using this formula to see if you can isolate the error:

if(and(FAN VOLT = 120 V, FAN HP = 1), 16 A, 0 A)

If that doesn't get an error, maybe you can post the family so we can take a look? If not, this formula should work.

if(and(Phase Multiplier = 1, and(FAN VOLT = 120 V, FAN HP = 1)), 16 A, 0 A)

[Anonymous]

Nice work,

FAN HP was indeed the culprit. It was the fact that FAN HP was a text parameter, rather than a numeric parameter. Once that was changed, it worked!

Thanks!