Conditional Formulas across worksheets

[Guest]

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

 

[Guest]

Try:-

=IF(Sheet1!J7>0,Sheet1!A7,0)

Mike

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

Is this possible? Help gratefully received.

Many thanks

 

[Bob Phillips]

=IF(Sheet1!J7>0,Sheet1!A7,0)

--
HTH

Bob

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

 

[Guest]

Thanks for your help and time

Try:-

=IF(Sheet1!J7>0,Sheet1!A7,0)

Mike

 

[Guest]

Thank you for your help and time. Appreciated.

=IF(Sheet1!J7>0,Sheet1!A7,0)

--
HTH

Bob

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