Prev: Sheet Names Disappeared
Next: Don Guillett ROCKS! is an Excel guru!
From: Glenda on 14 May 2010 14:03
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
From: Mike H on 14 May 2010 14:08
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
From: Lars-�ke Aspelin on 14 May 2010 14:10
On Fri, 14 May 2010 11:03:01 -0700, Glenda
<Glenda(a)discussions.microsoft.com> 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,D1>A1-C1),"Pass","Fail")

Hope this helps / Lars-�ke


From: Eduardo on 14 May 2010 14:40
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
 | 
Pages: 1
Prev: Sheet Names Disappeared
Next: Don Guillett ROCKS! is an Excel guru!