undersize assessment
- Thread starter ucesmik
- Start date
- Joined
- May 20, 2011
- Messages
- 1,518
- Reaction score
- 1
- Points
- 0
- Location
- Mississauga, Canada
- Excel Version(s)
- Excel 2016
Please describe the logic that is to be used to get those desired results.
WizzardOfOz
New member
- Joined
- Sep 4, 2013
- Messages
- 184
- Reaction score
- 0
- Points
- 0
- Location
- Australia
- Excel Version(s)
- 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)
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)