1. I got error. I made my file by using 'variable range' so I guess this error is due to using 'range'
2. I used 'IF' fuction to restrict. But it don't apply
I need to solve this problem for my work until this week.
So I fully want you to help.
One problem: You write phi(a,a') = atan(XXX) 180/pi.
Mathcad will assume angles are in radians, so later, when you ask for sin(phi(a,a') you will get an error.
Mathcad is unit aware; don't put in unit conversion factors.
I opened your sheet, and it broke because your excel data isn't in the sheet, and the read excel function failed.
Can't go further.