| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
trying to make a formula for percent if greater than a value
I got it to work, but the formula averages a zero when the statement is
false. How do I make a false statement render a blank cell, or to drop the value? If the value is 0, then I want it excluded, I only want to average values greater than 0. Thanks. "SteveG" wrote: Enter the formula as you normally would. =AVERAGE(IF(A1:A80,A1:A8,FALSE)) When you are done typing in the formula, rather than hitting the Enter key, hit the Ctrl, Shift & Enter keys simultaneously. That will create the {} around the formula automatically. Don't type them in yourself. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=499913 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for selecting the greater of two values? | Excel Worksheet Functions | |||
| Is it possible? | Excel Worksheet Functions | |||
| How do I make this formula? | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) | |||
Threaded Mode
