Formula with named ranges not working

[papermonkey]

this is the formula.
=IFERROR(SLOPE(IF(RANGE1=DATA1;IF(RANGE2=DATA2;IF(RANGE3=DATA3)));IF(RANGE1=DATA1;IF(RANGE2=DATA2;IF(RANGE4=DATA4))));"ERROR")

1. will this formula valid?
2. when i copy this formula to another workbook it is not creating a link to the master workbook. how to create a link ?
3. the formula works but when i hit f2 inside the cell the data converts to ERROR. dont know why.

RANGE1,2,3,4 = named ranges of separate column data.
DATA1,2,3,4 = constant data criteria like year, month, employee id, salary

please help. thanks.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ula-named-ranges-not-working.html#post5129149

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.