Problem with proj.lin function

Question

I have a problem with the proj.lin function.
My setup:
Windows 10 Home Single Language, version 21H2.
Microsoft Office Home and Student 2016.
Microsoft® Excel® 2016 MSO (Version 2302 Build 16.0.16130.20186) 32-bit
Depending on the data entered, the proj.lin function have to return two or more values, but it is only returning one of them.
Example:

I tried reloading Office, but it didn't help.

oliverscheurich · Answer

Luis_Vilanovavila&nbsp;=PROJ.LIN($B$2:$B$7;$D$2:$E$7)The formula works in my Excel 2013 sheet if i copy this formula across range H8:I8 and confirm with ctrl+shift+enter as an arrayformula.&nbsp;

luis_vilanovavila · Answer

OliverScheurich- thank you; you solved my problem. I hope that the 4 pawns become 4 queens soon. And a good sunday.&nbsp;

Forum Discussion

Problem with proj.lin function

2 Replies

Resources