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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Missing Variables
Hi,
could you please provide an example will help, is $I valid only if E match a value in B and G in C, if not which is the result you are expecting "bob" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Missing Variables
I have modified the formula below and it returns a value of FALSE when it
should return a value of .171314 =IF(E2=[Team Data.xls]Data'!$B,IF(G2='[Team Data.xls]Data'!$C,AG2 / (((P2 / ('[Team Data.xls]Data'!$J / 5)) * TmFGM) - Q2),)) The values for each variable, beginning with AG2, are =296 / (((2417 / (19375 / 5)) * 3421) - 406) "Eduardo" wrote: Hi, could you please provide an example will help, is $I valid only if E match a value in B and G in C, if not which is the result you are expecting "bob" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Missing Variables
Hi,
=IF(AND(E2==[Team Data.xls]Data'!$B,G2=[Team Data.xls]Data'!$C),AG2/(P2/('[Team Data.xls]Data'!$J/5)*TmFGM-Q2)) "bob" wrote: I have modified the formula below and it returns a value of FALSE when it should return a value of .171314 =IF(E2=[Team Data.xls]Data'!$B,IF(G2='[Team Data.xls]Data'!$C,AG2 / (((P2 / ('[Team Data.xls]Data'!$J / 5)) * TmFGM) - Q2),)) The values for each variable, beginning with AG2, are =296 / (((2417 / (19375 / 5)) * 3421) - 406) "Eduardo" wrote: Hi, could you please provide an example will help, is $I valid only if E match a value in B and G in C, if not which is the result you are expecting "bob" wrote: 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 |
Reply |
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) |