| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| IF Statement | New Users to Excel | |||
| How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
Linear Mode
