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
Solved by D. H. in 30 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
Looking to have Lat. Long in - Degrees Minutes Decimal Minutes
120* 23.2345'
Can you do that?
Solved by O. H. in 26 mins
Hi! How can I change the setting to find the sine angle in degrees?