# If Statement just not working

Options
✭✭✭✭✭

i'm struggling with the if statement in general. I have the following set up in my sheet

Configuration Column - drop down to allow 4 choices (90, 180, 270, 360)

Overall Length - needs to take choice from drop down and have a formula apply depending on the answer (formula applied is using a result from another calculated column - Belt Length Tier)

Belt Length Tier - calculated field

I've tried to just simplify the formula and only have it look for 1 choice and can't get the if statement to work.

this is what i have so far:

=if[Configuration]@row=90,[Belt Length Tier]*0.25,0

on its own [Belt Length Tier]*0.25 formula works, but as soon as I par it with the if formula I receive the dreaded #UNPARSEABLE

I even tried just trying out the if statement with a real easy result, with total failure.

=if[Configuration]@row=90,"YES","NO"

I have moved parentheses around so much, I'm not even sure that is my problem.

Thanks for the help

Tags:

• ✭✭✭✭✭
Options

Did you ever have one of those ah-ha moments?!! Well I just did. I didn't name the column correctly in my calculation. Now it works. Thanks for the help though.

• ✭✭✭✭✭✭
Options

Hi Liz,

Try this and let me know if it works.

=if([Configuration]@row=90,[Belt Length Tier]@row*0.25,0)

The above IF statement translates to: If the configuration on this row is equal to 90, multiply the Belt Length Tier on this row times 0.25. Otherwise, display 0.

Thanks,

Heather

• ✭✭✭✭✭
Options

I'm sorry but that doesn't work. It is exactly as I had it. Like I mentioned above, even the "yes","no" isn't working either for the true/false response

• ✭✭✭✭✭✭
Options

Can you please provide a screenshot (with private information blocked out)? This may help figure things out.

• ✭✭✭✭✭