| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
