I do not understand why results are not equal for two different columns with same values. Maybe someone can enlighten me of something I'm not aware of.
Example:
1st column is made up of cells with =IF(AND($E9="x",G9>=1),G9," ")
2nd column is made up of cells with =IF($A9=TRUE,$G9,0)
The resulting values for both columns are the same for G9.
MIN(Range) of the 1st produces a number.
MIN(Range) of the 2nd produces " ". I copied and "pasted special" values in to remove the formulas and still get " "
Any suggestions please?
Bob
Bookmarks