| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logic If formula - multi-parameters can not get to work??
techexpressinc (Programmer) Apr 10, 2009
I can not get the if formula to work for checking multiple cells. I have it working with one cell but I need it to working check two cells. I am checking for the value less than 5 in multiple cells and if it is put a one in the output cell for a counter. It works for one cell checking. =IF(AC2<6,1,0) This works. Below this does not work: I need to check multiple cells thou I tried below and it fails?? =IF(((AC2<6) or (AD2<6)),1,0) Any good ideas on how to adjust it? Thanks Russ at Scaninc.org -- |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Logic If formula - multi-parameters can not get to work??
Any good ideas on how to adjust it?
Yes, read up on the OR function. Try this: =IF(or(AC2<6,AD2<6),1,0) Regards, Fred "Tech Express" wrote in message ... techexpressinc (Programmer) Apr 10, 2009 I can not get the if formula to work for checking multiple cells. I have it working with one cell but I need it to working check two cells. I am checking for the value less than 5 in multiple cells and if it is put a one in the output cell for a counter. It works for one cell checking. =IF(AC2<6,1,0) This works. Below this does not work: I need to check multiple cells thou I tried below and it fails?? =IF(((AC2<6) or (AD2<6)),1,0) Any good ideas on how to adjust it? Thanks Russ at Scaninc.org -- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Logic If formula - multi-parameters can not get to work??
You need to use OR as a function:
=IF(OR((AC2<6), (AD2<6)),1,0) -- Gary''s Student - gsnu200845 "Tech Express" wrote: techexpressinc (Programmer) Apr 10, 2009 I can not get the if formula to work for checking multiple cells. I have it working with one cell but I need it to working check two cells. I am checking for the value less than 5 in multiple cells and if it is put a one in the output cell for a counter. It works for one cell checking. =IF(AC2<6,1,0) This works. Below this does not work: I need to check multiple cells thou I tried below and it fails?? =IF(((AC2<6) or (AD2<6)),1,0) Any good ideas on how to adjust it? Thanks Russ at Scaninc.org -- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Logic If formula - multi-parameters can not get to work??
It Work! Thanks.
-- Russ at scaninc.org "Fred Smith" wrote: Any good ideas on how to adjust it? Yes, read up on the OR function. Try this: =IF(or(AC2<6,AD2<6),1,0) Regards, Fred "Tech Express" wrote in message ... techexpressinc (Programmer) Apr 10, 2009 I can not get the if formula to work for checking multiple cells. I have it working with one cell but I need it to working check two cells. I am checking for the value less than 5 in multiple cells and if it is put a one in the output cell for a counter. It works for one cell checking. =IF(AC2<6,1,0) This works. Below this does not work: I need to check multiple cells thou I tried below and it fails?? =IF(((AC2<6) or (AD2<6)),1,0) Any good ideas on how to adjust it? Thanks Russ at Scaninc.org -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF logic formula | New Users to Excel | |||
| Logic Formula | Excel Worksheet Functions | |||
| multi pages in work book | Excel Discussion (Misc queries) | |||
| Cannot get Wildcards in Parameters to work in MS Query/Excel2003 | Excel Discussion (Misc queries) | |||
| Viewing Multi-worksheets in same work-book | Excel Worksheet Functions | |||
Linear Mode
