I'm using the following to enter values in cell B1 on sheet 2:
=(Sheet1!A1>Sheet1!A2)*100+(Sheet1!A1=Sheet1!A2)*50
The problem is, the formula is responding to empty cells. When both cells are empty, the formula is accepting that the cells are equaled and returning a value of one. This is messing up everything. I want the formula to ignore the cell if the cell is empty. What should I do?
Thanks.
=(Sheet1!A1>Sheet1!A2)*100+(Sheet1!A1=Sheet1!A2)*50
The problem is, the formula is responding to empty cells. When both cells are empty, the formula is accepting that the cells are equaled and returning a value of one. This is messing up everything. I want the formula to ignore the cell if the cell is empty. What should I do?
Thanks.