View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default 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