IF formula doesn't work?
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!
Answers

=IF([column 1]@row < 6500, [column 1]@row, "6,500")
edit:
Nevermind there... I just gave you the same formula basically. I tried plugging your formula into a sheet and it works with no issues.

Thank you @Carson Penticuff ,
but I have tried that as well and it still didn't work it still spits out the 17,000 number as before but still works with the other columns the same as well.
any other advice?

Maybe try testing on another sheet? Both formulas are working for me.

How are your cells being populated? If there is no formatting applied, text values are left justified (both column in your screenshot) and numerical values are right justified. You are also going to want to remove the quotes and comma from the output (6500 instead of "6,500") so that your formula outputs a usable number instead fo a text string.

thank you, Currently when they fill out a form it out it fills another column (we'll call it the original column) (this column is also not shown on the screenshots) but since it doesn't populate the ($) or the (,) I have to copy it over to another column with a formula (column 1). then I have to adjust it based on the amount and that's why I need column 2. I need column 1 so I know the total with the ($) and (,) and then column 2 is so I know how much we would charge. that is also why the 6,500 has the comma.

Have you tried formatting the field that is populated by the form to show $ and then just run your IF formula off of that?

Yes but When i have it auto generate into a document it doesn't show up.

I didn't realize you needed it for document generation. In that case, run your IF off of the original field since it should be stored as numerical values and then apply whatever formula you are using to get the $ and , in place after you get the output from the IF.

Thank you!
It works now :)
Help Article Resources
Categories
Check out the Formula Handbook template!