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) |