Nested IF Function
 

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

Nested IF Function
 

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

regards
FSt1

"Scott" wrote:

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

Nested IF Function
 

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

"Scott" wrote:

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