At this NOAA web site, if you fill in a speed 0-3, you get an error message.
Their function returns the error message...

"Winds need to be above 3 MPH and below 110 MPH."

Looks like the temperature has a valid range also...
"Temperatures need to be above -50 °F and below 50 °F"
"Temperatures need be to above -50 °C and below 10 °C"

I was messing around with the equation. If working in C°, I believe either
of these will work.

wc = Round(13.1266666666667 + 0.6215 * t - 12.2611111111111 * v ^ (0.16) +
0.4275 * t * v ^ (0.16))
or
wc = Round((5 * (1539 * t - 44140) * v ^ (0.16) + 33 * (339 * t + 7160)) /
18000)

--
Dana DeLouis
Win XP & Office 2003


"Tushar Mehta" wrote in message
om...
I know the formula is the same one as on the NOAA web site, but it
needs a 'threshold' to be applicable. To see why, just set the wind
speed to zero.

The NOAA web site implies -- but doesn't explicitly state that it is
valid for V = 3. See http://www.erh.noaa.gov/er/iln/tables.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
On 27 Mar 2005 12:31:29 -0800, "Carroll" wrote:

Function WindChill(WindSpeed_MPH, Temp_F°)

WindChill = Format((91.4 - (0.474677 - 0.020425 * WindSpeed_MPH +
0.303107 * WindSpeed_MPH ^ 0.5) * (91.4 - Temp_F°)), "0.0°")

End Function

I got the formula off the internet.

The formula you are using is the old definition. A few years ago it was
"updated" to :

= 35.74 + 0.6215*Temp - 35.75*Wind ^0.16 + 0.4275*Temp*Wind^0.16

for °F

For °C I just apply the conversion to the °F result.




--ron