# Checkbox Formula - Greater than

• 1
• Question
• Updated 2 years ago

I need to write the following formula for a checkbox field;

If [Tier Stage] = "Active" and [Weight] > 24, true.

The formulat I have in now returns no errors, but the boxes are not showing checked when criteria is true.

[Tier Stage] is a Text Field, [Weight] is numeric

• 284 Points

Posted 4 years ago

• 1
• 72,146 Points
try this

IF([Tier Stage] = "Active" and [Weight] > 24, true)
• 72,146 Points
be sure about your "fence posts" -  you might actually want to be true on Greater Than or Equal to 24.

IF([Tier Stage] = "Active" and [Weight] >= 24, true)
• 284 Points
I have tried both formulas.  The field does not contain an error when saving, but no boxes are showing checked in the records that qualify.  Any ideas why?
• 72,146 Points
On a record that is not checked, what value is on the field [Tier Stage] and it it possible it has a trailing or leading space in it.  What value is in  the field for weight?
• 284 Points
Thank you for making me think.  The value in the Weight field is a percent.  I changed from 24 to .2 and it's working great.   Thank you for your assistance.
• 72,146 Points
:)
• 300 Points
This is great I had a similar problem and didn't realize I needed to change my formula to .xx.  Makes sense if the field is a percentage.