I have a workbook containing a number of sheets.

In sheet 2 I want a conditional formula which says if cell J7 in sheet 1 is
0, then return the contents of cell A7 in sheet 1, otherwise return 0.

Is this possible? Help gratefully received.

Many thanks