PortoMarco
New Member
- Joined
- Jul 10, 2014
- Messages
- 21
Hi
How can I get my max function (and subsequently my min function) to ignore blank cells?
Here is my function:
=MAX(IF(Return!$A$3:$A$306=Analysis!P$63;IF(Return!$C$3:$C$306=Analysis!$L73;IF(Return!$D$3:$D$306=Analysis!$L$60;Return!$P$3:$P$306))))
my three pre-existing conditions work fine.
I want it to return the max value in the P column (3:306) and ignore the empty cells in that range. The problem is that the cells in P3:P306 are not really empty; they all have a vlookup so I guess excel is treating the "empty" cell as actually full (the formula) and returning a zero value.
How can I get my max function (and subsequently my min function) to ignore blank cells?
Here is my function:
=MAX(IF(Return!$A$3:$A$306=Analysis!P$63;IF(Return!$C$3:$C$306=Analysis!$L73;IF(Return!$D$3:$D$306=Analysis!$L$60;Return!$P$3:$P$306))))
my three pre-existing conditions work fine.
I want it to return the max value in the P column (3:306) and ignore the empty cells in that range. The problem is that the cells in P3:P306 are not really empty; they all have a vlookup so I guess excel is treating the "empty" cell as actually full (the formula) and returning a zero value.