| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for If "" AND "" are true...
I want to test to determine if the measurement in cell d1 is within
tolerance. The required dimension is in cell a1 and the positive tolerance is in cell b1, the negative tolerance in cell c1, Pass/Fail is entered to cell e1. I would like the formula in cell e1 to be of the order of if d1 is <a1+b1 and a1-c1 then put "Pass" in the cell; if not, put "Fail" in the cell can't figure out how to make this work in excel HELP -- Glenda -- Glenda |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for If "" AND "" are true...
Hi,
Try this =IF(AND(D1=A1-B1,D1<=A1+C1),"Pass","Fail") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Glenda" wrote: I want to test to determine if the measurement in cell d1 is within tolerance. The required dimension is in cell a1 and the positive tolerance is in cell b1, the negative tolerance in cell c1, Pass/Fail is entered to cell e1. I would like the formula in cell e1 to be of the order of if d1 is <a1+b1 and a1-c1 then put "Pass" in the cell; if not, put "Fail" in the cell can't figure out how to make this work in excel HELP -- Glenda -- Glenda |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for If "" AND "" are true...
On Fri, 14 May 2010 11:03:01 -0700, Glenda
wrote: I want to test to determine if the measurement in cell d1 is within tolerance. The required dimension is in cell a1 and the positive tolerance is in cell b1, the negative tolerance in cell c1, Pass/Fail is entered to cell e1. I would like the formula in cell e1 to be of the order of if d1 is <a1+b1 and a1-c1 then put "Pass" in the cell; if not, put "Fail" in the cell can't figure out how to make this work in excel HELP -- Glenda Try this formula in E1: =IF(AND(D1<A1+B1,D1A1-C1),"Pass","Fail") Hope this helps / Lars-Åke |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for If "" AND "" are true...
Hi,
=if(and(d1<(a1+B1),d1(a1-c1)),"Pass","Fail") "Glenda" wrote: I want to test to determine if the measurement in cell d1 is within tolerance. The required dimension is in cell a1 and the positive tolerance is in cell b1, the negative tolerance in cell c1, Pass/Fail is entered to cell e1. I would like the formula in cell e1 to be of the order of if d1 is <a1+b1 and a1-c1 then put "Pass" in the cell; if not, put "Fail" in the cell can't figure out how to make this work in excel HELP -- Glenda -- Glenda |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Can you replace "TRUE" with " " in an exact formula? | Excel Worksheet Functions | |||
Linear Mode
