Conditional Formulas across worksheets
 

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

Conditional Formulas across worksheets
 

Try:-

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

Mike

"Skibee" wrote:

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

Conditional Formulas across worksheets
 

=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

Conditional Formulas across worksheets
 

Thanks for your help and time

"Mike H" wrote:

Try:-

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

Mike

"Skibee" wrote:

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

Conditional Formulas across worksheets
 

Thank you for your help and time. Appreciated.

"Bob Phillips" wrote:

=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