Excel: How to use Checkbox with IF Statement? 1

[rlee16]

I have a checkbox in my excel file. Depending on whether it is checked or not, I would like Cell A1 to grab value from either A2 or A3.

e.g.
Cell A1 = if(CheckBox1.Value = True,A2, A3)

I do not know how to properly write the syntax for this. Thanks in advance!

Richard

 

[TonyJollans]

Hi Richard,

Link your checkbox to a cell, say A4, then use
=IF(A4,A2,A3)

Enjoy,
Tony

 

[rlee16]

Thanks Tony,

Works like a charm!

Richard