Forum Discussion
Excel Formula help!
I am trying to create formulas from one sheet to another in a workbook. This is what I want to do. Sheet 2 has the formula If a cell in sheet 1 has anything in it then a cell in sheet 2 has an X. ...
First formula:
=IF('Sheet 1'!A1="", "", "X")
Second formula:
=IF(OR('Sheet 1'!B2<>"", 'Sheet 1'!B1=""), "", 'Sheet 1'!B1)
Thank you so much, that's perfect!