=IF(Sheet1!J70,Sheet1!A7,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Skibee" wrote in message
...
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