Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here's one I'm having a problem with . . . too many variable conditions in a
formula. I need all of these conditions tested in one formula. First of all, I've worked on this for quite a while. Not just asking for a gimme! I just can't get a 3rd condition into my equation. If an input number is = one value, OR =< the value of another number . . . AND if it's value is < a 3rd number, then do such and such. EX: The value of an input number is .035. The nominal (target) number is ..03. There is a tolerance range, AND an inner limit as well. So my input number is .005 than .03. If the number is more than .01 or .01 < .03, then it's out of tolerance. And an "OT" would appear in a cell. That one's easy. No problemo. Now . . . in another cell (the "Alert" column) I need to determine whether the value uses 75% of the allowable + or - tolerance. But not more than 100%, or that would be in the OT column. No problem with the 75% part. My formula puts a "75% Used" in the cell if I use more than 75% of either the upper or lower end of the tolerance. Like . .. . .03 is +/- .01. So if the input number is .009, that would be 75% or more, AND under 100%. If it was -.009, that's more than 75% on the minus side. So I need the "75% Used" in the cell there, too. Because it's still under the low limit of -.01, and therefore not OT. If it was .0074, neither 75% nor OT would come into play. Here's what I've tried . . . =IF(AND(H10=M10,H10<(N10+0.0001)),"75% + Used","") .. . . is what I used first. But this only determined whether the data was 75%, and <100%. problem is, I need to work in another variable. =IF(AND(H10=M10, <- checks to see it the data is higher than 75%. H10<(N10+0.0001)), <- checks to see if it's less than 100% ??? I need one more condition to check that the data isn't <75% as well!!!! "75% + Used","") <- what to do if it's 75% (+ or -) and less than 100%. . . . Let's say that X = the difference between input# and target. Like input is .035, target .03. Diff is +.005. And I'm comparing that difference to a calculated value. In this case, 75% of .01 (and -.01). So y is .01 and z is -.01 in this case. So my formula has to "say" . . . if x=75% of y OR =<75% of z AND less than y then do this . . . What a day! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Statement with Multiple Arguments | Excel Worksheet Functions | |||
Multiple Column Conditional Formatting | New Users to Excel | |||
IF Statement equalling multiple words. Please Help | Excel Discussion (Misc queries) | |||
Help, Multiple conditional calculation | New Users to Excel | |||
Multiple FIND functions in Conditional Formatting | Excel Worksheet Functions |