View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Calculating a complicated formula

"Chris" wrote in message
...
I am doing an MTO for work and need to calculate a swale concrete lining.
On
paper, easy. But I cannot get the formula to work on excel.

Obviously you have SQRT(number) and a couple of POWER(number) x thickness
x
length but I cannot get it to work.

The slope of the swale is 1.5 times the base, therefore you have 1.5 x b
squared + d squared and then this answer is sqrt x 2


=SQRT(1.5*B^2+d^2)*2

for both sides


don't understand this bit

+ b for total length x thickness x length.


nor this really, although it will end with *t*l