Solving for Wetbulb Temperature with Excel 5

[navynuke]

I am relatively new to working with VBA although I am comfortable in my Excel abilities. I am trying to solve a system of equations for the wetbulb temperature(twb) given the dry bulb temperature (tdb), relative humidity (relh), and atmospheric pressure (Patm). The equations are as follows:

Wsat = 0.622(Pws/(Patm-Pws))

W = 0.622(Pw/(Patm-Pw))

Pw = relh*Pws

Pws = Exp(c8/twb+c9+c10*twb+c11xtwb^2+c12*twb^3+c13*log(twb))

W = ((1093-0.556*twb)*Wsat-0.240(tdb-twb))/(1093+0.444*tdb-twb)

I know that it is within Excel's power to solve for twb but at this point in my experience I cannot get the programming to work. Obviously the whole mess can be written in one big equation with the unknown on both sides of the equation but how do I get Excel to solve for it? Any assistance would be greatly appreciated.

 

[chichuck]

rb1957,

truer (sp?) words.... I give you a star. And if it were possible, a star to "someone" as well!


Regards,

chichuck