Home

Mind is blank: I can't create a spreadsheet with the following equations

%3CLINGO-SUB%20id%3D%22lingo-sub-497565%22%20slang%3D%22en-US%22%3EMind%20is%20blank%3A%20I%20can't%20create%20a%20spreadsheet%20with%20the%20following%20equations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-497565%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20some%20reason%2C%20I%20can't%20shake%20my%20head%20around%20this%20to%20build%20a%20simple%20spreadsheet%20where%20one%20just%20needs%20to%20enter%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Etemperature%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Ewind%20speed%20%3C%2FSTRONG%3Ewhere%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWindchill%20Temperature%20%3D%200.045%3CEM%3E(5.2735%3C%2FEM%3ESQROOT(W)%20%2B%2010.45%20-%200.2778%3CEM%3EW)%3C%2FEM%3E(T%20-%2033.0)%2B33%20WCF%20%3D%201.1626%3CEM%3E(5.2735%3C%2FEM%3ESQROOT(W)%20%2B%2010.45%20-%200.2778%3CEM%3EW)%3C%2FEM%3E(33.0%20-%20T)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20%3A%3C%2FP%3E%3CP%3EET%20%3D%20equivalent%20temperature%20(degrees%20Celsius)%3C%2FP%3E%3CP%3EWCF%20%3D%20wind%20chill%20factor%20(Watts%20per%20square%20metre)%3C%2FP%3E%3CP%3ESQROOT%20%3D%20square%20root%20function%3C%2FP%3E%3CP%3EW%20%3D%20wind%20speed%20(Km%2Fhr)%3C%2FP%3E%3CP%3ET%20%3D%20air%20temperature%20(degrees%20Celsius)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20greatly%20appreciated!%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-497565%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
JustANoob
Occasional Visitor

For some reason, I can't shake my head around this to build a simple spreadsheet where one just needs to enter the temperature and wind speed where:

 

Windchill Temperature = 0.045(5.2735SQROOT(W) + 10.45 - 0.2778W)(T - 33.0)+33 WCF = 1.1626(5.2735SQROOT(W) + 10.45 - 0.2778W)(33.0 - T)

 

and :

ET = equivalent temperature (degrees Celsius)

WCF = wind chill factor (Watts per square metre)

SQROOT = square root function

W = wind speed (Km/hr)

T = air temperature (degrees Celsius)

 

Any help is greatly appreciated! Thank you.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies