Not sure if there's any spreadsheet wonks out there.. I've got a table with values. Given an PGAref value of say 0.23, I want to interpolate between the values along the highlighted Class D row. I only have this discrete table of values, there are no functions associated with those values. I want to do this strictly in Libreoffice Calc or Excel. Is there a way to do this other than using a terrible set of nested IF statements?
Fosstodon is an English speaking Mastodon instance that is open to anyone who is interested in technology; particularly free & open source software.