W
William Wagner
Using Excel 2002 - the following formula =IF B4>I3,(B4),(I3) works ok in my
spreadsheet. When I change the "greater than" to "less than", the formula
works ok except all cells below the current cell display the results to the
end of spreadsheet. To eliminate showing all the results in this column, I
added the following to the formula - =IF (B4=" "," ",(B4<I3,(B4),(I3))) -
This formula does not work - comes up with a #VALUE result. Is there a
quick fix to this novice problem?
spreadsheet. When I change the "greater than" to "less than", the formula
works ok except all cells below the current cell display the results to the
end of spreadsheet. To eliminate showing all the results in this column, I
added the following to the formula - =IF (B4=" "," ",(B4<I3,(B4),(I3))) -
This formula does not work - comes up with a #VALUE result. Is there a
quick fix to this novice problem?