Check Box Formula Problem

[rpriestley]

I am looking at data in cell A2. I am using simple formula =a2

Now I have used a check box which ticked true is displayed in cell F2 and when unticked false is displayed in cell F2.

What I would like to do is the following: If F2 is false then look at data in A2 but if F2 is True then display zero.

Thanks

Is it possible to get F2 to display zero or 1 instead of true or false

Thank You

Robin

 

[Richard Schollar]

Hi Robin

=IF(F2,0,A2)

I'm not sure if you can set it so that it displays 1 or 0, but you could choose a n adjacent helper column and use a formula to display 0 or 1:

=F2+0

which will display 1 for True and 0 for False.