papermonkey
New Member
- Joined
- Jun 25, 2018
- Messages
- 5
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 ?
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.
=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 ?
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.