Formula for If "" AND "" are true...

G

Glenda

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
 
M

Mike H

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.
 
L

Lars-Åke Aspelin

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
Click to expand...

Try this formula in E1:

=IF(AND(D1<A1+B1,D1>A1-C1),"Pass","Fail")

Hope this helps / Lars-Åke
 
Top