If and Formula

Hi. I am doing a calculation in make with a lot of if and but one is calculating incorrectly and I can’t see what’s wrong. When I test the criteria Classic and the price at 3500, it returns 0.160.1375 instead of 0.1375. I think it is adding the Premium to it as well but the Range is definitelly Classic so not sure why that would be.

Your equal operators are invalid as they are in plain text.

Hope this helps! If you are still having trouble, please provide more details.

@samliew

1 Like