| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Missing Variables
An array formula reads as follows:
=AG2 / (((P2 / ('[Team Data.xls]Data'$I / 5)) * '[Team Data.xls]Data'$J) - Q2) The problem is that the formula is missing the following: [TeamData]Data!$I is only valid, if E2 in the current file equals a value in $B in the TeamData file AND and if G2 equals a value in $C. I need to know how to modify the formula above to include these additional components. Thank you. Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| Too Many Variables | Excel Worksheet Functions | |||
| Three Variables | Excel Worksheet Functions | |||
| Toolbars Missing, And option to Add Missing | Excel Discussion (Misc queries) | |||
| Two variables | Excel Discussion (Misc queries) | |||
Threaded Mode
