| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
should it be if() or another logical function?
I want to get a 1 if true, a 0 if false...
What I'm looking at is: if the total of 3 cells=0 AND the average of 5 other cells =30, then 1, else 0 ....typing this it seems like an and or an or function without the tue/false return...what do you think? Thanks! -- Gina |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
should it be if() or another logical function?
=IF(AND(AVERAGE(A1:A5)=30,SUM(B1:B3)=0),1,0)
Dave -- Brevity is the soul of wit. "Gina" wrote: I want to get a 1 if true, a 0 if false... What I'm looking at is: if the total of 3 cells=0 AND the average of 5 other cells =30, then 1, else 0 ...typing this it seems like an and or an or function without the tue/false return...what do you think? Thanks! -- Gina |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
should it be if() or another logical function?
Try this:
=--AND(SUM(A1:A3)=0,AVERAGE(B1:B5)=30) "Gina" wrote: I want to get a 1 if true, a 0 if false... What I'm looking at is: if the total of 3 cells=0 AND the average of 5 other cells =30, then 1, else 0 ...typing this it seems like an and or an or function without the tue/false return...what do you think? Thanks! -- Gina |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| wild card with if logical function | Excel Worksheet Functions | |||
| Custom function | Excel Worksheet Functions | |||
| Logical Function Question | Excel Worksheet Functions | |||
| using logical functions as criteria with the SUMIF function | Excel Worksheet Functions | |||
Linear Mode
