If Statement that Copies to another Sheet

  • Thread starter Thread starter sunpanther
  • Start date Start date
S

sunpanther

I am not sure how to create an IF statement that does the following:

If a cell is >1 then copy the contents of another cell onto another
sheet.

Can this be done? And does this make sense

Thank you for your help!!

:confused:
 
It can't be done - worksheet functions can only return values to their
calling cells.

However, you can put this in the cell in your second sheet:

J1: =IF(Sheet1!A1>1, Sheet1!B1, "")



which will display the contents of Sheet1!B1 if Sheet1A1 > 1, else will
display a null string.
 
Back
Top