software

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(aw9lt;=25),or(if(aw9gt;=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.

Try:
=IF(OR(AW9lt;=25,AW9gt;=16,AH9=3,AI9=3,AJ9=3,AK9=3,AL9 =3),4,0)

HTH
--
AP

quot;CBZquot; gt; a écrit dans le message de
news
gt; I am trying to determine why my 'if' statement does not work. Can anyone
gt; detect the error.
gt;
gt; I am a novice at this and would appreciate the guidance from an more
gt; experienced user.
gt;
gt;
gt;
=(if(aw9lt;=25),or(if(aw9gt;=16),or(if(ah=3)),or(if(ai =3)),or(ifaj=3)),or(if(ak=
3)),or(if(al=3)),4,0)
gt;
gt; The 4 indicates the true response, the 0- the false.
Thank you so much. It works perfectly.

Celeste

quot;Ardus Petusquot; wrote:

gt; Try:
gt; =IF(OR(AW9lt;=25,AW9gt;=16,AH9=3,AI9=3,AJ9=3,AK9=3,AL9 =3),4,0)
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;CBZquot; gt; a écrit dans le message de
gt; news
gt; gt; I am trying to determine why my 'if' statement does not work. Can anyone
gt; gt; detect the error.
gt; gt;
gt; gt; I am a novice at this and would appreciate the guidance from an more
gt; gt; experienced user.
gt; gt;
gt; gt;
gt; gt;
gt; =(if(aw9lt;=25),or(if(aw9gt;=16),or(if(ah=3)),or(if(ai =3)),or(ifaj=3)),or(if(ak=
gt; 3)),or(if(al=3)),4,0)
gt; gt;
gt; gt; The 4 indicates the true response, the 0- the false.
gt;
gt;
gt;