| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formulas and worksheets | Excel Discussion (Misc queries) | |||
| Formulas in Worksheets | Excel Discussion (Misc queries) | |||
| Formulas across worksheets are not updating | Excel Discussion (Misc queries) | |||
| Using formulas betweek worksheets | Excel Discussion (Misc queries) | |||
| Conditional formulas between multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
