Below is a formula I'm trying to perfect. Goal, I need to compare cell $A$10
to $A$6 for a match (results for column B can only be 0 or 1). If A10 and A6
match, then I need to evaluate if $B$6=1. If A6=1 then I need the cell with
the formula to equal 0, if A6 <1 then I need the formula to then evaluate
the additional three cell references and if all is true the result should
return 1 if not it should return 0. Right now I'm getting a "False" result.
Results should only be limited to 0 or 1. Can you tell me what I've got
wrong?


The formula is in cell B14
=IF($A$10=$A$6,IF($B$6<0,0),IF('Skin Alterations'!$D$9="PU",IF('Skin
Alterations'!$E$9="A",IF('Skin Alterations'!$G9="I",1,0),0),0))

Thanks in advance for any help you can provide.

HI

Look at the first part of your formula, .....If($B$6<0,0)......

replace the closing paranthesis with a comma and add a closing paranthesis
at the end of the formula:

=IF($A$10=$A$6,IF($B$6<0,0,IF('Skin Alterations'!$D$9="PU",IF('Skin
Alterations'!$E$9="A",IF('Skin Alterations'!$G9="I",1,0),0),0)))

Best reards,
Per

"Pat" skrev i meddelelsen
...
Below is a formula I'm trying to perfect. Goal, I need to compare cell
$A$10
to $A$6 for a match (results for column B can only be 0 or 1). If A10 and
A6
match, then I need to evaluate if $B$6=1. If A6=1 then I need the cell
with
the formula to equal 0, if A6 <1 then I need the formula to then evaluate
the additional three cell references and if all is true the result should
return 1 if not it should return 0. Right now I'm getting a "False"
result.
Results should only be limited to 0 or 1. Can you tell me what I've got
wrong?


The formula is in cell B14
=IF($A$10=$A$6,IF($B$6<0,0),IF('Skin Alterations'!$D$9="PU",IF('Skin
Alterations'!$E$9="A",IF('Skin Alterations'!$G9="I",1,0),0),0))

Thanks in advance for any help you can provide.

SEE MY NEWER POST AS HAVE SIGNIFICANT TYPE IN INFORMATION BELOW!

"Pat" wrote:

Below is a formula I'm trying to perfect. Goal, I need to compare cell $A$10
to $A$6 for a match (results for column B can only be 0 or 1). If A10 and A6
match, then I need to evaluate if $B$6=1. If A6=1 then I need the cell with
the formula to equal 0, if A6 <1 then I need the formula to then evaluate
the additional three cell references and if all is true the result should
return 1 if not it should return 0. Right now I'm getting a "False" result.
Results should only be limited to 0 or 1. Can you tell me what I've got
wrong?


The formula is in cell B14
=IF($A$10=$A$6,IF($B$6<0,0),IF('Skin Alterations'!$D$9="PU",IF('Skin
Alterations'!$E$9="A",IF('Skin Alterations'!$G9="I",1,0),0),0))

Thanks in advance for any help you can provide.

Thank Per, that helped sum, however, if the evaluation turns out false, I'm
still getting a "False" result in the formula, and would really prefer it be
a 0 if possible. I amended the formula as you suggested to the following:

=IF($A$10=$A$6,IF($B$6<0,0,IF('Skin Alterations'!$D$9="PU",IF('Skin
Alterations'!$E$9="A",IF('Skin Alterations'!$G9="I",1,0),0),0)))

I'm I missing a 0 somewhere near the end of the formula that would give the
zero result versus the "False" result?

Thanks again for your help!

"Per Jessen" wrote:

HI

Look at the first part of your formula, .....If($B$6<0,0)......

replace the closing paranthesis with a comma and add a closing paranthesis
at the end of the formula:

=IF($A$10=$A$6,IF($B$6<0,0,IF('Skin Alterations'!$D$9="PU",IF('Skin
Alterations'!$E$9="A",IF('Skin Alterations'!$G9="I",1,0),0),0)))

Best reards,
Per

"Pat" skrev i meddelelsen
...
Below is a formula I'm trying to perfect. Goal, I need to compare cell
$A$10
to $A$6 for a match (results for column B can only be 0 or 1). If A10 and
A6
match, then I need to evaluate if $B$6=1. If A6=1 then I need the cell
with
the formula to equal 0, if A6 <1 then I need the formula to then evaluate
the additional three cell references and if all is true the result should
return 1 if not it should return 0. Right now I'm getting a "False"
result.
Results should only be limited to 0 or 1. Can you tell me what I've got
wrong?


The formula is in cell B14
=IF($A$10=$A$6,IF($B$6<0,0),IF('Skin Alterations'!$D$9="PU",IF('Skin
Alterations'!$E$9="A",IF('Skin Alterations'!$G9="I",1,0),0),0))

Thanks in advance for any help you can provide.

Try this: (all on one line)

=IF($A$10=$A$6,IF($B$6<0,0,
--AND('Skin Alterations'!$D$9="PU",
'Skin Alterations'!$E$9="A",
'Skin Alterations'!$G9="I")),0)

--
Biff
Microsoft Excel MVP


"Pat" wrote in message
...
Thank Per, that helped sum, however, if the evaluation turns out false,
I'm
still getting a "False" result in the formula, and would really prefer it
be
a 0 if possible. I amended the formula as you suggested to the following:

=IF($A$10=$A$6,IF($B$6<0,0,IF('Skin Alterations'!$D$9="PU",IF('Skin
Alterations'!$E$9="A",IF('Skin Alterations'!$G9="I",1,0),0),0)))

I'm I missing a 0 somewhere near the end of the formula that would give
the
zero result versus the "False" result?

Thanks again for your help!

"Per Jessen" wrote:

HI

Look at the first part of your formula, .....If($B$6<0,0)......

replace the closing paranthesis with a comma and add a closing
paranthesis
at the end of the formula:

=IF($A$10=$A$6,IF($B$6<0,0,IF('Skin Alterations'!$D$9="PU",IF('Skin
Alterations'!$E$9="A",IF('Skin Alterations'!$G9="I",1,0),0),0)))

Best reards,
Per

"Pat" skrev i meddelelsen
...
Below is a formula I'm trying to perfect. Goal, I need to compare cell
$A$10
to $A$6 for a match (results for column B can only be 0 or 1). If A10
and
A6
match, then I need to evaluate if $B$6=1. If A6=1 then I need the cell
with
the formula to equal 0, if A6 <1 then I need the formula to then
evaluate
the additional three cell references and if all is true the result
should
return 1 if not it should return 0. Right now I'm getting a "False"
result.
Results should only be limited to 0 or 1. Can you tell me what I've
got
wrong?


The formula is in cell B14
=IF($A$10=$A$6,IF($B$6<0,0),IF('Skin Alterations'!$D$9="PU",IF('Skin
Alterations'!$E$9="A",IF('Skin Alterations'!$G9="I",1,0),0),0))

Thanks in advance for any help you can provide.