Forum Discussion

sitravel's avatar
sitravel
Copper Contributor
Jan 08, 2025

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. If the cell in sheet 1 is empty then the cell in sheet 2 also remains empty (I could possibly put a zero in instead of leaving it blank)

Second Formula;

If a cell in sheet 1 has a date in it (say b1) then the date needs to be put into a cell in sheet 2 BUT if the cell next to it in sheet 1 (b2) also has a date in it then nothing goes into the cell in sheet 2!

 

Loving trying to work this out but run into a brick wall! Any help would be much appreciated!

excel
Excel on Mac
Formulas and Functions

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jan 08, 2025

    First formula:

    =IF('Sheet 1'!A1="", "", "X")

    Second formula:

    =IF(OR('Sheet 1'!B2<>"", 'Sheet 1'!B1=""), "", 'Sheet 1'!B1)