Nested IF Function

  • Thread starter Thread starter Scott
  • Start date Start date
S

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Min Value 3
nested if 5
"" + Number = #VALUE! 6
Need Help in Simple Lookup Function 14
Autofill equations 4
Using multiple IF statements 8
I can't copy and paste equations 0
IF and OR nested function 3

Back
Top