Here are some problems that our users have asked and received explanations on
I need a formulas using only this functions , Mod
IF
and
or
round
roundup
sqrt
min
max
sin
cos
to figure out how many hrs does a take to do a job
Example. 10 to 20k 30 hrs
20001 to 30 k 60 hrs
and so on increments of 10 k increments of 30 hrs
i cant calculate sin(20*pi*0) 0-80 i need some assistants
Solved by A. F. in 20 mins
I am trying to figure out the average speed and direction between 0-45, 45-90,91+ in degrees. The direction (DIR) is given in degrees while the speed (SPD) is given in mph. I am trying to input the formula into column V.
Solved by V. U. in 17 mins
Hi I have a column which gives me daily temperatures since 1975 till 2017. I am trying to calculate the cumulative deviation of temperature and trigger a payout if the cumulative is greater than 150 degrees celcius or 250 degrees. The deviation is based on 'triggers' so if the daily max temp is 30 and the trigger is 31 then the cumulative deviation is -1 and so on. I have a set of 6 triggers - 31, 33 35.5 38 39.5 and 39. How can I calculate this on excel?