Get instant live expert help on I need help with formulas for length
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need these formulas in excel format
(Length)2+ (Change in Height)2).5
10% is Design Standard
(Length of Rake)*Catenary %
Parameter of the Catenary
C *(cosh ((L/2)/C)-1
C *(sinh ((Length of Rake)/C)
Sum of Arc Lengths
(Length of Rake * (Catenary) *0.67
Sum Areas of Deduction
Solved by X. H. in 21 mins
I need a formula to say IF Column A length > 0 AND Column Q length = 0 THEN Column I = "N"
Solved by S. H. in 14 mins
trying to find out the length of time an employee has been and for this to update daily
Solved by M. U. in 28 mins
I need a formula that will take a length and width of a product and times it by 2 (to make a door) and then divide it to show how many 6 meter lengths of that product are required to make the door. I have it that it works up until 9 quantity but after that it doesn't calculate correctly. I must mention the length and with relate back to another cell where you can change the length and width to what size of door you are making and the length comes from another tab within the excel workbook. ie for 1 door you require 3 lengths so for 10 doors you would require 30 lengths but it calculates at 28 lengths
Solved by T. S. in 19 mins
I am wanting to create an if statement to make rules for our shipping methods we have different sizes & weight limitations
So the first set of weights and dimension are
= 2nd class large letter
Max Length MaxWidth MaxHeight Max Weight
35.3 25 2.5 250
= royal mail tracked
Max Length MaxWidth MaxHeight Max Weight
61 46 46 2000
Anything over both change to = dpd
Solved by M. Q. in 18 mins