Checkbox, "IF" function does not work

Question

Checkbox, "IF" function does not work

Anonymous

Hello everyone,

Firstly, sorry for Non-English Office, however any language settings are blocked (company computer). Quick Danish lesson:

HVIS = IF

SAND = TRUE

FALSK = FALSE

Now, I made a simple checkbox that gives TRUE/FALSE in cell H3. Then typed in a formula in cell G21: =IF(H3="TRUE";1;0). However, when I check the box, TRUE/FALSE change, but the value in G21 does not. It remain 0 or any other value I type instead of 0. I tried to manipulate with symbols, however without any success.

It seems all right looking at Microsoft's guidelines, but just does not work. Can someone tell what is wrong?

***Post moved by the moderator to the appropriate forum category.***

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Answer accepted by question author

1 additional answer

Answer 1

Anonymous

TRUE & FALSE are not text so take the quotes from around them when checking in your IF statement

(I would also remove the quotes from around your 1 & 0)

=HVIS($H$3=SAND;1;0)

Answer 2

Anonymous

Sir, you got me!

Share via

Checkbox, "IF" function does not work

1 additional answer