# Check Box Formula Problem

#### rpriestley

##### Board Regular
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

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### Richard Schollar

##### MrExcel MVP
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.

Replies
4
Views
183
Replies
10
Views
264
Replies
5
Views
111
Replies
2
Views
274
Replies
2
Views
176

1,191,614
Messages
5,987,690
Members
440,104
Latest member
thigarette

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back