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.