NetNathan
Lifetime Supporting Member
I have a dewpoint sensor the is 4-20mA out across -148 to 68 Deg F.
I want to find out what the dewpoint reading should be for each mA.
I have a column of cells that are showing 4-20mA in 1mA steps.
The column next to it starts at -148 and last cell is 68. How do I tell Excel to evenly divide the range across the middle cells to cover 5-19mA range?
I want to find out what the dewpoint reading should be for each mA.
I have a column of cells that are showing 4-20mA in 1mA steps.
The column next to it starts at -148 and last cell is 68. How do I tell Excel to evenly divide the range across the middle cells to cover 5-19mA range?