Forum Discussion
Luis_Vilanovavila
Mar 05, 2023Copper Contributor
Problem with proj.lin function
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.1...
OliverScheurich
Mar 05, 2023Gold Contributor
=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.
- Luis_VilanovavilaMar 05, 2023Copper Contributor
OliverScheurich- thank you; you solved my problem. I hope that the 4 pawns become 4 queens soon. And a good sunday.