| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking formula type (reference to other worksheet or not)
In the worksheet cells I have two types of formulas: references to
another worksheet or summing cells within this worksheet. Is there a formula to tell those two apart? TIA, topola |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking formula type (reference to other worksheet or not)
I'm not sure if this will help, but references to a different file include
the "[" and "]" characters. "topola" wrote: In the worksheet cells I have two types of formulas: references to another worksheet or summing cells within this worksheet. Is there a formula to tell those two apart? TIA, topola |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking formula type (reference to other worksheet or not)
On 20 Lip, 16:14, Fred Coulter
wrote: I'm not sure if this will help, but references to a different file include the "[" and "]" characters. "topola" wrote: In the worksheet cells I have two types of formulas: references to another worksheet or summing cells within this worksheet. Is there a formula to tell those two apart? TIA, topola Fred, thanx for your help. The formula looks like this: =othersheetname!A1 and "!" sign would be sufficient for testing. I don't know however how to operate on the formula, not on the cell value. topola |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference a Worksheet Tab in Formula | Excel Worksheet Functions | |||
| Cannot see formula descriptions in worksheet as I type a formula. | Excel Worksheet Functions | |||
| two worksheet reference formula help | Excel Worksheet Functions | |||
| Need help with A 3-D reference type formula (real novice here) | Excel Worksheet Functions | |||
| Provide a way to turn off auto-checking excel formulas as I type t | Excel Discussion (Misc queries) | |||
Hybrid Mode
