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
Ijaz
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)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.