My conditions are to check for the closest upper value within an array of cells compared with the 'temperature' input, and correspond with the output being that closest temperature.
What I'm trying to do is have the cell check if its value is the same as that of another, and if so, to change...
Homework Statement
using the table of values supplied (a pdf document), construct an excel spreadsheet wherein a value can be input from 200-2250 and output will be air's specific heat capacity at that temperature.
Homework Equations
Cp= H2-H1/T2-T1
The Attempt at a Solution
I...