#### PortoMarco

##### New Member

- Joined
- Jul 10, 2014

- Messages
- 21

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.