IF Statement Check box, not returning check

ShaunaT
ShaunaT
edited 12/09/19 in Formulas and Functions

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?

Tags:

Comments

  • L_123
    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.

  • [email protected] perfect thank you! That's exactly what I was doing wrong! Fixed!! :)