IF formula doesn't work?

Options

Hello,

I am using an IF formula to generate numbers but it doesn't seem to work when i have numbers over 10,000 and it just spits the same number back out. See below:

the formula I am use is: =IF([column 1]@row >= 6500, "6,500", [column 1]@row)

so I'm trying to get it to say if column 1 is over 6,500 then only write 6,500 but any number under it should be the same as the one in the first column.

Thanks!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!