As an alternative to what Ken has already provided:
Example One
Code:
=IF(Nominal_Size<=0.625,IF(Length<=0.875,0.031,IF(Length>=1,0.063,0.094)),0.094)
However, your original formulas don't appear to provide an answer for the example data:
Length=0.9 and Nominal_Size=0.5 other than 0.094, is this by design?
Example Two
Again, the original formulas don't seem to take into account certain number ranges, i.e.:
Length=0.9 and Nominal_Size=0.5
Length=1.1 and Nominal_Size=0.5
Length=1.2 and Nominal_Size=0.5
are you missing some < or > signs, or do you intend to ignore these examples?
Bookmarks