materialperson
New Member
- Joined
- Oct 10, 2017
- Messages
- 3
I am calculating a minimum thickness to use for a steel part and need to have the output in standard thicknesses.
<tbody>
</tbody>
The standard sizes of material used are 0.25, 0.375, 0.5, 0.625, 0.75, 0.875, 1.00, 1.25, 1.375, ....6 inches.
What would be the best formula to use? IF/AND, VLOOKUP, RANGE_LOOKUP, or is there a better one to use?
The calculated thickness cells contain Roundup and IF functions, the length of the numbers is dictated by ASME code/ specific figures involved in the calculation.
Is there a way to have <= and >= in a lookup function?
Thanks
Minimum Thickness (In.) Calculated | Actual Thickness of part to be used | |
0.3794 | 0.5 | |
1.6784 | 1.75 | |
3.2493 | 3.375 | |
4.7854 | 4.875 |
<tbody>
</tbody>
The standard sizes of material used are 0.25, 0.375, 0.5, 0.625, 0.75, 0.875, 1.00, 1.25, 1.375, ....6 inches.
What would be the best formula to use? IF/AND, VLOOKUP, RANGE_LOOKUP, or is there a better one to use?
The calculated thickness cells contain Roundup and IF functions, the length of the numbers is dictated by ASME code/ specific figures involved in the calculation.
Is there a way to have <= and >= in a lookup function?
Thanks