Results 1 to 4 of 4

Thread: undersize assessment

  1. #1

    undersize assessment

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear All,
    Please can you assist amendment to equation in column F so that I can get same answer with equation in column F to desired answer manually inserted in column G
    Thanks in advance
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    Please describe the logic that is to be used to get those desired results.

  3. #3
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Excel Version
    Office 365
    If you look at your column H and I you will note that there is a perfect linear correlation with
    Flange diam = 0.915497124 * Velocity + 0.173924952 and I suggest this is the formula that you are wanting.
    Secondly your "suggested answer" column G is wrong, you are merely showing the nearest velocity in your lookup table.
    Warning a simple lookup is not going to give you the correct answer as what you are wanting is which item in Col H is closest to Col C. As an example 460 is closest to 500 then 400 but lookup will return 400 (>= but < next)

  4. #4
    Many thanks, your suggestion is highly appreciated

Posting Permissions

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