Nested IF Function

[Scott]

Anyone,

Is there a function where if the results of an equation are not above a
value that you need, to make that cell blank? For instance, =A1*A2, if the
answer to that equation is less than .01, just leave the cell blank.

Thank You

 

[FSt1]

hi
yes.
=if(A1*A2<.01,"",A1*A2)

regards
FSt1

 

[Jerry W. Lewis]

Depends on what you mean by "blank". Visually, you can use "" as already
suggested. For data to be plotted use #N/A. Either way, formulas may need
to be adjusted that reference ranges containing the cell. Nothing but an
empty cell behaves exactly like an empty cell in every context.

Jerry