Auto Checkbox Completion

Hi All,

I am trying to get a formula to work that checks a box based on a column with percentage. I.e when 100% is reached the box is checked.

I have tried the following to no avail

=IF([Compliance]5 = "100%", 1, 0)

Similarly I would like to have another column ticked if non compliant i.e <100% again I have tried

=IF([Compliance]5 = "<100%", 1, 0)

Any help would be great

Thanks

Find more posts tagged with

Construction

Formulas

Comments

JamesR

Leo,

Try

=IF([Compliance]5 = 1, 1, 0)

100% =1

50% = .5

Leo Plant

Thanks James,

That works great for the 100% forcing checking of the compliant column. How would I get the non compliant column to be checked if it is less that 100% comliance? I have tried =IF([Compliance]5 = <1, 1, 0) but that has not worked.

Many Thanks

Leo

Atus Bartal

Dear Leo,

You don't need "=" in the formula, just put =IF([Compliance]5 <1, 1, 0).

Is it what you mean?

Atus