Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement combining average
Hi,
I am creating an efficiency report and I am stuck on a problem. I am getting a false statement when all the cells have no information in it when I actually need that cell to remain blank when there is nothing to report. Here is the formula I am using: =IF(COUNT(A39:C39),AVERAGE(A39:C39)) -- B9M |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement combining average
=IF(COUNT(A39:C39)=0,"",AVERAGE(A39:C39))
-- Gary''s Student - gsnu200906 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement combining average
Excel 2007:
=IFERROR(AVERAGE(A39:C39),"") Regards, Bernd |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement combining average
"Black9Medic" wrote:
I am getting a false statement when all the cells have no information in it when I actually need that cell to remain blank when there is nothing to report. Here is the formula I am using: =IF(COUNT(A39:C39),AVERAGE(A39:C39)) Look at the Help page for the IF function. It has a 3rd parameter, which defaults to FALSE. The IF function returns the value of the 3rd parameter when COUNT() returns zero, exactly the condition you describe. Your formula should be: =IF(COUNT(A39:C39), AVERAGE(A39:C39), "") ----- original message ----- "Black9Medic" wrote in message ... Hi, I am creating an efficiency report and I am stuck on a problem. I am getting a false statement when all the cells have no information in it when I actually need that cell to remain blank when there is nothing to report. Here is the formula I am using: =IF(COUNT(A39:C39),AVERAGE(A39:C39)) -- B9M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Average, Offset & Vlookup | Excel Worksheet Functions | |||
Combining a OR and a AND in an IF statement | Excel Discussion (Misc queries) | |||
Combining AND/OR in an IF statement | Excel Worksheet Functions | |||
Combining a Vlook up with and If then statement | Excel Worksheet Functions | |||
combining an if statement | Excel Worksheet Functions |