Can anyone help me out with the following, I have tried to use the OR
function but I have not been able to get the result I want. Its a little
complicated but here goes.

I am trying to formulate an inspection report, here is the layout plus example

Column A = 32.00 (Nominal)
Column B = 0.005 (- tolerance)
Column C = 0.00 (+ tolerance)
Column D = 31.00 (Result)
Coulmn E = -01.00 (Deviation from nominal (D - A))
Column F = I am only wanting to populate column F if the result is out of
spec ie (if D is less than A-B = D-(A-B) or if D is greater than A+C =
D-(A+C)) if non of these are true leave blank.

Hope this makes sense.

try:

=IF(OR(D1A1+C1,D1<A1-B1),"out of spec","")

--
Gary''s Student - gsnu200776


"The Rook" wrote:

Can anyone help me out with the following, I have tried to use the OR
function but I have not been able to get the result I want. Its a little
complicated but here goes.

I am trying to formulate an inspection report, here is the layout plus example

Column A = 32.00 (Nominal)
Column B = 0.005 (- tolerance)
Column C = 0.00 (+ tolerance)
Column D = 31.00 (Result)
Coulmn E = -01.00 (Deviation from nominal (D - A))
Column F = I am only wanting to populate column F if the result is out of
spec ie (if D is less than A-B = D-(A-B) or if D is greater than A+C =
D-(A+C)) if non of these are true leave blank.

Hope this makes sense.

Thanks for that, but I need to to populate how much it is out of spec. Can
this be done?

"Gary''s Student" wrote:

try:

=IF(OR(D1A1+C1,D1<A1-B1),"out of spec","")

--
Gary''s Student - gsnu200776


"The Rook" wrote:

Can anyone help me out with the following, I have tried to use the OR
function but I have not been able to get the result I want. Its a little
complicated but here goes.

I am trying to formulate an inspection report, here is the layout plus example

Column A = 32.00 (Nominal)
Column B = 0.005 (- tolerance)
Column C = 0.00 (+ tolerance)
Column D = 31.00 (Result)
Coulmn E = -01.00 (Deviation from nominal (D - A))
Column F = I am only wanting to populate column F if the result is out of
spec ie (if D is less than A-B = D-(A-B) or if D is greater than A+C =
D-(A+C)) if non of these are true leave blank.

Hope this makes sense.

If you tell us how to calculate this population figure, then yes.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"The Rook" wrote in message
...
Thanks for that, but I need to to populate how much it is out of spec.
Can
this be done?

"Gary''s Student" wrote:

try:

=IF(OR(D1A1+C1,D1<A1-B1),"out of spec","")

--
Gary''s Student - gsnu200776


"The Rook" wrote:

Can anyone help me out with the following, I have tried to use the OR
function but I have not been able to get the result I want. Its a
little
complicated but here goes.

I am trying to formulate an inspection report, here is the layout plus
example

Column A = 32.00 (Nominal)
Column B = 0.005 (- tolerance)
Column C = 0.00 (+ tolerance)
Column D = 31.00 (Result)
Coulmn E = -01.00 (Deviation from nominal (D - A))
Column F = I am only wanting to populate column F if the result is out
of
spec ie (if D is less than A-B = D-(A-B) or if D is greater than A+C =
D-(A+C)) if non of these are true leave blank.

Hope this makes sense.

As per my 1st post:

Column F = I am only wanting to populate column F if the result is out of
spec ie (if D is less than A-B then result D-(A-B) or if D is greater than
A+C then result D-(A+C)) if non of these are true leave blank.




"Bob Phillips" wrote:

If you tell us how to calculate this population figure, then yes.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"The Rook" wrote in message
...
Thanks for that, but I need to to populate how much it is out of spec.
Can
this be done?

"Gary''s Student" wrote:

try:

=IF(OR(D1A1+C1,D1<A1-B1),"out of spec","")

--
Gary''s Student - gsnu200776


"The Rook" wrote:

Can anyone help me out with the following, I have tried to use the OR
function but I have not been able to get the result I want. Its a
little
complicated but here goes.

I am trying to formulate an inspection report, here is the layout plus
example

Column A = 32.00 (Nominal)
Column B = 0.005 (- tolerance)
Column C = 0.00 (+ tolerance)
Column D = 31.00 (Result)
Coulmn E = -01.00 (Deviation from nominal (D - A))
Column F = I am only wanting to populate column F if the result is out
of
spec ie (if D is less than A-B = D-(A-B) or if D is greater than A+C =
D-(A+C)) if non of these are true leave blank.

Hope this makes sense.

=IF(D1<A1-B1,D1-(A1-B1),IF(D1A1+C1,D1-(A1+C1),""))

[so I don't know why you were looking for an OR function?]
--
David Biddulph

"The Rook" wrote in message
...
As per my 1st post:

Column F = I am only wanting to populate column F if the result is out of
spec ie (if D is less than A-B then result D-(A-B) or if D is greater than
A+C then result D-(A+C)) if non of these are true leave blank.

"Bob Phillips" wrote:

If you tell us how to calculate this population figure, then yes.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"The Rook" wrote in message
...
Thanks for that, but I need to to populate how much it is out of spec.
Can
this be done?

"Gary''s Student" wrote:

try:

=IF(OR(D1A1+C1,D1<A1-B1),"out of spec","")

--
Gary''s Student - gsnu200776


"The Rook" wrote:

Can anyone help me out with the following, I have tried to use the
OR
function but I have not been able to get the result I want. Its a
little
complicated but here goes.

I am trying to formulate an inspection report, here is the layout
plus
example

Column A = 32.00 (Nominal)
Column B = 0.005 (- tolerance)
Column C = 0.00 (+ tolerance)
Column D = 31.00 (Result)
Coulmn E = -01.00 (Deviation from nominal (D - A))
Column F = I am only wanting to populate column F if the result is
out
of
spec ie (if D is less than A-B = D-(A-B) or if D is greater than A+C
=
D-(A+C)) if non of these are true leave blank.

Hope this makes sense.