Help

[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?

 

[Jerry W. Lewis]

=IF B4>I3,(B4),(I3)
is not a valid formula; you should copy/paste formulas into your posts to
avoid typographical errors. Your working formula may have been
=IF(B4>I3,B4,I3)
but then your observation that "all cells below the current cell display the
results to the end of spreadsheet" is not clear.

=IF (B4=" "," ",(B4<I3,(B4),(I3)))
is also not a valid formula, although the alternative that Excel 2003
suggests (removing the space before the first parenthesis) would return
#VALUE! You may have intended
=IF(B4=" "," ",IF(B4<I3,B4,I3))

Jerry

 

[William Wagner]

Thanks Jerry. Sorry I forgot the first (. Your suggestion in the last
sentence to add the IF before the final calculation worked just fine. Still
not clear why the < formula filled all the cells below; at this point I
really don't care because the other formula is working just fine. Been
around Excel for many years without any formal training and I guess it shows