Error when using IF statement in formula with mathematics equation

Tags: #<Tag:0x00007f0b00d5b788>

Hi, I encountered an error while using the IF statement in a cell. Please see the link below.
https://jsfiddle.net/chesterjdlow/0hu19p4L/5/

I set a condition in the formula:
If the input value in column A1 is smaller than a certain fix value in column B1, it should have returned 0. Instead, the value in A1 is being calculation which will definitely produce an error.

I expect the IF statement is going to work like how we usually set it up in MS Excel, but apparently not. Can this be fixed? Thank you.

Hey @gorfange

the ((A1-1.7)^1.5) is an incorrect value that is why the formula returns the error. That should not happen and hopefully it won’t in our new formula engine (planned for Q1 this year).