Using MakeCode Editor
I need to apply a formula based on two variables; Temp & Humidity
After calculating the value ;
if Value =< 30 then show smiley face "LEDs"
else if value > 30 and =< 40 then show a Face "LEDs"
else show Sad face (LEDs)
the formula is to calculate the Heat Index, the attached file may explain more,
=IF((A2*9/5+32)<=80,A2,IF(AND(B2<13,((A2*9/5+32)>80),((A2*9/5+32)<112)),(((-42.379+2.04901523*(A2*9/5+32)+10.14333127*B2-0.22475541*(A2*9/5+32)*B2-0.00683783*(A2*9/5+32)*(A2*9/5+32)-0.05481717*B2*B2+0.00122874*(A2*9/5+32)*(A2*9/5+32)*B2+0.00085282*(A2*9/5+32)*B2*B2-0.00000199*(A2*9/5+32)*(A2*9/5+32)*B2*B2)-32)*5/9)-(((13-B2)/4)*SQRT((17-ABS((A2*9/5+32)-95))/17)),IF(AND(B2>85,((A2*9/5+32)>80),((A2*9/5+32)<87)),(((-42.379+2.04901523*(A2*9/5+32)+10.14333127*B2-0.22475541*(A2*9/5+32)*B2-0.00683783*(A2*9/5+32)*(A2*9/5+32)-0.05481717*B2*B2+0.00122874*(A2*9/5+32)*(A2*9/5+32)*B2+0.00085282*(A2*9/5+32)*B2*B2-0.00000199*(A2*9/5+32)*(A2*9/5+32)*B2*B2)-32)*5/9)+((B2-85)/10)*((87-(A2*9/5+32))/5),(((-42.379+2.04901523*(A2*9/5+32)+10.14333127*B2-0.22475541*(A2*9/5+32)*B2-0.00683783*(A2*9/5+32)*(A2*9/5+32)-0.05481717*B2*B2+0.00122874*(A2*9/5+32)*(A2*9/5+32)*B2+0.00085282*(A2*9/5+32)*B2*B2-0.00000199*(A2*9/5+32)*(A2*9/5+32)*B2*B2)-32)*5/9))))
Hello, I have read the details provided and i am positive i can provide quality work,please contact me to discuss more on the project deadline and some other few things
I DO NOT OUTSOURCE
I have been a freelancer for the past 8 years, I believe that my experience and skill in this background will prove to be of great help to you. Contact me to discuss more on the details