If Statement not working because referenced cell contains a formula

[JustHooch]

I know I have done this before but I can't remember how. I have an ActiveX control checkbox with the linked cell in G14. I need to write an IF statement in cell H14 based on if the result is TRUE or FALSE.

If G14 = FALSE then H14 = 0
If G14 = TRUE then H14 = 1

Normally I would us the formula =IF(G14="FALSE","0","1"), however I am getting a 1 in H14 not matter what is in G14. I am assuming because the result in G14 is not actually entered text.

Note I have tried with the format of cell G14 being both General and Text with the same result.

I am not using Count in H14 because I have the same scenario in row 15-20 as well, the different only being that TRUE is not always = to 1 for each row in column H.

Please help me out.

 

[sheetspread]

Did you try removing the quotes around False?

 

[jtakw]

Hi,

As sheetspread mentioned, you have quotes around FALSE in your formula, that makes the formula Test for the Text "FALSE", Not the Logical FALSE as what's in G14, so it's Always producing 1.

You should ALSO remove the quotes around 0 and 1 in your formula, as is, they are Text 0 and 1, not numbers.

 

[My Aswer Is This]

Why not put this script in the CheckBox:

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then Range("H14").Value = 1
If CheckBox1.Value = False Then Range("H14").Value = 0
End Sub

 

[Peter_SSs]

Another formula option for G14 is simply
=G14*1

.. I have the same scenario in row 15-20 as well, the different only being that TRUE is not always = to 1 for each row in column H.

For those other rows, just change the 1 in the formula above to the value you want if the G column value is True.

 

[JustHooch]

Removing the quotes did it. thank you.

 

[jtakw]

You're welcome, welcome to the forum.

Try Peter's way, it's simpler and does the same thing.