Thread: IF function question

Hi,

I have an excel file where I want to select a checkbox and then have the data next to the check box go into another cell. I have figured out how to make a corresponding cell show TRUE or FALSE depending on the checked status of the box. So I was thinking of using an IF function based on the TRUE/FALSE designation from check box.

For example, check box in A1, If A2=TRUE then I want A3 cell contents copied and moved to G33.

Thank you very much,

August

A formula can't "push" data to another cell, it can only "pull" data to the cell in which the formula resides. So you'll need to put the formula in cell G33, something like:

=IF(A2,A3,"")

Hope this helps.

Pete