I have found a bug in the RTD-based features in the beta (as of 2024-08-30) versions of Excel version 2409. There is a detailed description of the RTD mechanism with links to Microsoft source material ...

An earlier Design Idea described how to linearize the output of an RTD (resistance-temperature-detector) sensor and how to calculate the resistor values using a spreadsheet (Reference 1). That idea ...