Hello,

I have a question regarding a formula that I believe is possible by some one with more experience with formula's then myself. I have about 3 days worth of experience working with excel formula's.

Here is the scenario:

I have a spread sheet with a formula for a MAX in a cell at the top of a column. This cell is at the top of the page in a section that is a locked window pane. This Cell is I7. The data in which I am getting the max from is row 12 to row 70 in the same column but they have a formula in every other cell.

Formula in every other cell in I12:I70 is:

=IF(AND(I12="",I13=""),"",(I12+I13)/2)

Due to this formula it places a 100% if there isn't any data in the previous cells in the row.

So what I have is I12 through I70 with a blank cell and then a 100%

Now back to Cell I7 and the max formula. I need a formula that has to logical conditions.

Logical 1: IF the number is >0% use it

Logical 2: IF the number is <100% use it

I tried something like this but ended up with an error

=MAX(IF(AND(I12:I70<100%,I12:I70>0%),I12:I70,""""))

Sorry if this is too in depth or not enough info. I will gladly provide what is needed to get help.