#1
|
|||
|
|||
Search Range Within Cell or Cells
This is obviously my first post on here, so please forgive me if I don't do something right. I am trying to put together a sheet that has inputs for various chemical constituents of a steel, and I would like to determine which grade it is...see below example of what I'm trying to do. I need help with the formulas for searching a range of numbers and outputting if it falls into that category or not. I would love to do this without VBA but will default to the experts on here. Thanks in advance!
Inputs Input 1 C: 0.15 Mn: 0.75 Input 2 C: 0.22 Mn: 0.35 Steel Grades L175 Grade C: 0.00 to 0.21 Mn: 0.00 to 0.60 L210 Grade C: 0.00 to 0.22 Mn: 0.00 to 0.90 |
#2
|
||||
|
||||
Hi and welcome
at first glance there seems to be an overlap in your steel grades Suppose C =0.10 and Mn=0.50 What would be the grade?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copying text range of cells to different cells adds an extra line | jpb103 | Word VBA | 2 | 07-23-2014 12:22 PM |
Search the text in 3rd cell by using texts in 2 cells | Shinaj | Excel Programming | 1 | 05-09-2014 09:17 AM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
Moving formula range multiple cells when moving sum over one cell | FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |