Howdy, I will make this short and as clear as possible.
(what I need is) >> Purple Field to grab HBW numbers if the conditions of the ENTER TENSILE field meet the parameters I'm trying to specify in the function, which all relate to that ENTER TENSILE number being greater than or equal to numbers in the other fields.
My experience with excel, .001. I just created my first function which works properly:
The one I am trying to INCORPORATE into this of the "if # in CELL "X" is Greater than # in CELL "Y" but LESS than CELL "Z" then grab # from CELL "Q"
Since the function at the very top is simply repetitive is a sense feel free to use a truncated form of that example if it is possible to incorporate my other needed functions into it.
All help is appreciated
Attached is a copy of the sheet I am working on, I was trying out the greater than but less than function in K10 just to see if I could get it working, then work on incorporating it into the function in "M"... I just learned how to merge cells so I am unsure as how to refer to those cells when technically they take up multiple row and columns... but anyway, the PURPLE box is the place I need my number to come out. I want whatever I input into the RED "Enter Tensile" field to "POINT" to one of the numbers in the "HBW" fields.
We get tensile numbers like, 57,580 or 109,670 and so forth. And occasionally numbers fall right on the dot. And basically they have me working off this typed up sheet any you have to figure this stuff in your head, which isn't difficult, but absolutely unnecessary in this technological age... heck, it wasn't necessary in the age of the ABACUS!!! So I took it upon myself to streamline this aspect of the job for myself and any future user to come along. Not to mention it can reduce the human error component which can run rampant if left unchecked.
Question
needsata
Howdy, I will make this short and as clear as possible.
(what I need is) >> Purple Field to grab HBW numbers if the conditions of the ENTER TENSILE field meet the parameters I'm trying to specify in the function, which all relate to that ENTER TENSILE number being greater than or equal to numbers in the other fields.
My experience with excel, .001. I just created my first function which works properly:
--------
=IF(J4=D3,C3,IF(J4=D5,C5,IF(J4=D7,C7,IF(J4=D9,C9,IF(J4=D11,C11,IF(J4=D13,C13,IF(J4=D15,C15,IF(J4=D17,C17,IF(J4=D19,C19,IF(J4=D21,C21,IF(J4=D23,C23,IF(J4=D25,C25,IF(J4=D27,C27,IF(J4=D29,C29,IF(J4=D31,C31,IF(J4=D33,C33,IF(J4=D35,C35,IF
(J4=D37,C37,IF(J4=D39,C39,IF(J4=D41,C41,IF(J4=D43,C43,IF(J4=D45,C45,IF(J4=D47,C47,IF(J4=D49,C49,IF(J4=D51,C51,IF(J4=D53,C53,IF(J4=D55,C55,IF(J4=D57,C57,IF(J4=D59,C59,IF(J4=G3,F3,IF(J4=G5,F5,IF(J4=G7,F7,IF(J4=G9,F9,IF(J4=G11,F11,IF
(J4=G13,F13,IF(J4=G15,F15,IF(J4=G17,F17,IF(J4=G19,F19,IF(J4=G21,F21,IF(J4=G23,F23,IF(J4=G25,F25,IF(J4=G27,F27,IF(J4=G29,F29,IF(J4=G31,F31,IF(J4=G33,F33,IF(J4=G35,F35,IF(J4=G37,F37,IF(J4=G39,F39,IF(J4=G41,F41,IF
(J4=G43,F43))))))))))))))))))))))))))))))))))))))))))))))))))
--------
The one I am trying to INCORPORATE into this of the "if # in CELL "X" is Greater than # in CELL "Y" but LESS than CELL "Z" then grab # from CELL "Q"
Since the function at the very top is simply repetitive is a sense feel free to use a truncated form of that example if it is possible to incorporate my other needed functions into it.
All help is appreciated
Attached is a copy of the sheet I am working on, I was trying out the greater than but less than function in K10 just to see if I could get it working, then work on incorporating it into the function in "M"... I just learned how to merge cells so I am unsure as how to refer to those cells when technically they take up multiple row and columns... but anyway, the PURPLE box is the place I need my number to come out. I want whatever I input into the RED "Enter Tensile" field to "POINT" to one of the numbers in the "HBW" fields.
We get tensile numbers like, 57,580 or 109,670 and so forth. And occasionally numbers fall right on the dot. And basically they have me working off this typed up sheet any you have to figure this stuff in your head, which isn't difficult, but absolutely unnecessary in this technological age... heck, it wasn't necessary in the age of the ABACUS!!! So I took it upon myself to streamline this aspect of the job for myself and any future user to come along. Not to mention it can reduce the human error component which can run rampant if left unchecked.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts