Im trying to compute the temp and pressure of different altitudes using the formulas attached, but my pressures' values seems to be off. How would I fix that

also shown how I tried to put this equation on excel.

>> this is the equation i used for the first cell on pressure column. =IF(A2:A101>11,K4*EXP((-9.81/(8.3144598*216.66)) * (A2:A101-11)),G2*POWER(B2:B101/F2,(-9.81 /(8.3144598*H2))))

Home Insert Draw Page Layout Formulas Data Review View Automate Q Tell me Exercise: The Standard Atmosphere - A well-formatted table form of the standard atmosphere showing Temperature and Pressure in SI units for altitudes in 0.25km increments up to 25km (note that they can check results using Table B-2 of brandt.) - Well-formatted graphs (for the same range of altitudes as the table) of - Temperature versus altitude - Pressure versus altitude Background: Gradient Layer In a gradient layer the temperature is described by a linear function T=T1+Th(hh1) Th is the slope of the gradient region, such as in the Troposhpere region seen in Brandt Fig. 2.4. Th is negative if the temperature is decreasing with altitude, and positive if the temperature increases with altitude. T1 and h1 are the temperature and altitude at the bottom of the gradient layer. Knowing the temperature, the pressure can be calculated according to: P=P1(T1T)1/(x) where R is the specific gas constant, and g is the acceleration of gravity at sea level. Note that the temperatures used in this equation must be measured in an absolute scale such as Kelvin (SI) or degrees Rankine (US Customary). Isothermal Layer In an isothermal layer, the temperature is simply constant T=T1 and the pressure may be computed by P=P1e(g/RT)(hh) where P1 is the pressure at the bottom of that isothermal layer