Hi,

I am trying to set up a spreadsheet where you input master data on Sheet1,
then depending on what options are not checked off (with an 1), that row of
data will not appear on Sheet2.

I thought the easiest way would be to create an If statement, something like:
=IF(Sheet1!A11,Sheet1!A1,do not display this line at all)

Obviously, that doesn't work! Is there a function that will allow this to
happen?

Also, in the "VAlue_if_TRUE" spot, is it possible to tell it do display 2
cells of data?

Thanks!!!