0

How do I tell MS Excel to use the contents from one cell if data exists (this data can be positive negative or zero). If the data does not exist in said cell, use contents from another cell?

Ryan
  • 1

1 Answers1

1

If there is anything in A1 then use it, else use B1

=IF(ISBLANK(A1),B1,A1)