IF Statement Check box, not returning check

ShaunaT

Hello, 

I have a sheet that I am saying if a score is over 80 to check the box. The formula itself seems to be working as it is returning the 1 however I want it to check the box not show me the value. 

 

Any ideas what I'm missing here?

L_123

usually you should post the formula you are testing so we know what you did and don't have to guess.

 

=if([column2]@row > 80,1,0)

also

=if([column2]@row > 80, true,false)

should work.

If it is showing a value my guess is you used the first formula I posted but put the 1 in parenthesis as seen below

=if([column2]@row > 80, "1","0")

which will post the 1 as a text value instead of a numeric value and post the text instead of checking the box.

ShaunaT

L@123 perfect thank you! That's exactly what I was doing wrong! Fixed!!