how do I fix my 'if' statement?
 

I am trying to determine why my 'if' statement does not work. Can anyone
detect the error.

I am a novice at this and would appreciate the guidance from an more
experienced user.


=(if(aw9<=25),or(if(aw9=16),or(if(ah=3)),or(if(ai =3)),or(ifaj=3)),or(if(ak=3)),or(if(al=3)),4,0)

The 4 indicates the true response, the 0- the false.

how do I fix my 'if' statement?
 

Try:
=IF(OR(AW9<=25,AW9=16,AH9=3,AI9=3,AJ9=3,AK9=3,AL9 =3),4,0)

HTH
--
AP

"CBZ" a écrit dans le message de
...
I am trying to determine why my 'if' statement does not work. Can anyone
detect the error.

I am a novice at this and would appreciate the guidance from an more
experienced user.



=(if(aw9<=25),or(if(aw9=16),or(if(ah=3)),or(if(ai =3)),or(ifaj=3)),or(if(ak=
3)),or(if(al=3)),4,0)

The 4 indicates the true response, the 0- the false.

how do I fix my 'if' statement?
 

Thank you so much. It works perfectly.

Celeste

"Ardus Petus" wrote:

Try:
=IF(OR(AW9<=25,AW9=16,AH9=3,AI9=3,AJ9=3,AK9=3,AL9 =3),4,0)

HTH
--
AP

"CBZ" a écrit dans le message de
...
I am trying to determine why my 'if' statement does not work. Can anyone
detect the error.

I am a novice at this and would appreciate the guidance from an more
experienced user.



=(if(aw9<=25),or(if(aw9=16),or(if(ah=3)),or(if(ai =3)),or(ifaj=3)),or(if(ak=
3)),or(if(al=3)),4,0)

The 4 indicates the true response, the 0- the false.