Help with Cell Formula

[Pat]

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 B6=1 then I need the cell with
the formula to equal 0, if B6 <>1 then I need the formula to then evaluate
the additional three cell references in the formal 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.

 

[Daniel.C]

Try :
=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)))
HTH
Daniel

 

[Pat]

Thanks for the help Daniel. I'm made the adjustment as suggested. The
formula now reads:

=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)))

However, with the current data, the cell B6 does contain a 0 and rather than
getting a zero in cell B10, I'm getting "False". I there a way to make it
return 0 instead? The goal is not to count B6 in B10 if B6 has already been
counted.

Thanks again for your help!

Pat

 

[Daniel.C]

=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)),0)
Daniel