Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I wrote an IF Statement that takes the Average of a group of cells based on a
certain condition. Here is the Formula: {=AVERAGE(IF(($A$30:$A$515=A1)*($H$30:$H$515=B1),$ Q$30:$Q$515))} When a add a second part to the IF statement, I receive the error message #Value! I am able to add a number, but not text. Example: {=AVERAGE(IF(($A$30:$A$515=A1)*($H$30:$H$515=B1),$ Q$30:$Q$515),"FALSE")} I want to add the "FALSE" LOGIC TO MY IF Statement. Ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Combining SUM Function with Nested If Statement | Excel Discussion (Misc queries) |