+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Friction loss calculation help

  1. #1
    Registered User
    Join Date
    01-20-2010
    Location
    Chicago IL.
    MS-Off Ver
    Excel 2003
    Posts
    5

    Friction loss calculation help

    i want to create a the following formula, but I just cant seem to get it done!


    FL={C}*{Q squared}*{L}

    FL= Friction Loss
    C= Coefficient of Hose
    Q squared = Total Flow
    L= Length of Hose

    thanks
    Last edited by trager551; 03-04-2010 at 04:44 PM.

  2. #2
    Registered User
    Join Date
    01-20-2010
    Location
    Chicago IL.
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Formula help

    actually that formula should read FL=C*Q/100 squared*L/100

  3. #3
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Formula help

    Perhaps you need:

    =C*(Q/100)^2*(L/100)

    Assuming C is in cell A1, Q is in A2 and L is in A3:

    =A1*(A2/100)^2*(A3/100)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1