| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Syntax for IF function
I would like to average the values in column B that lie between 2 values in column A. What I have so far is =average(if($A3:$A100, ...value in column A is less than 46 and greater than 34..., "" ""). I have been unable to express the second term with the correct syntax. I assumed that it would be ,<4634. So what is it?
Thank you in advance. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Syntax for IF function
this idea?
=AVERAGE(IF((C1:C212)*(C1:C21<5),C1:C21)) of course you realize that this is an array formula that must be entered using ctrl+shift+enter -- Don Guillett SalesAid Software "Sarah" wrote in message ... I would like to average the values in column B that lie between 2 values in column A. What I have so far is =average(if($A3:$A100, ...value in column A is less than 46 and greater than 34..., "" ""). I have been unable to express the second term with the correct syntax. I assumed that it would be ,<4634. So what is it? Thank you in advance. -- Sarah |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
