Unparseable error with "IF"

Options

Good day everyone,

I'm having issues with the IF formula on Smartsheet. I tried to do it as I typically do it on excel but I think I'm missing something in here.

Here's the formula that I'm using:

The thing what I want to do is if the Growth is over 100%, I want the result ">100%" in the cell. If not, I want the result of the operation on it.

Just like here:

But I get the Unparseable error over and over again.

Any help will be greatly appreciated.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!