I missed the squared part

Use this
=(IF(A3=45,24.5,IF(A3=65,3.17,0.305))*(B3100)^2*(C 3/100)

You don't have to divide the quantity and length by 100 before using this
formula

"Sheeloo" wrote:

Suppose you have one of 45, 65 , 100 in Col A
You have Quantity divided by 100 in Col B
Length divided by 100 in Col C
then enter this in D1
=(IF(A3=45,24.5,IF(A3=65,3.17,0.305))*B3*C3)

"John Holman" wrote:

Hi.

I am a not extremely proficient Excel user. I have been trying to figure
out how to tell Excel that I would like to create a formula.

I am trying to create this formula;

FL=C * Q2/100 * L/100
Where;
FL is Friction Loss
C is a varying Coeficient
Q is a varying Quantity in Litres divided by 100(then Squared)
L is Length in Meters divided by 100

C can equal 24.5 for 45mm
C can equal 3.17 for 65mm
C can equal .305 for 100mm

Looking for some help with this formula. For frequent users of excel
creating this formula may be simple, but I have been stumped! I will greatly
appreciate some assistance with this formula.

Thanks in advance.

John Holman