Nested IF Function

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
 
J

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
 

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

nested if 5
Min Value 3
Need Help in Simple Lookup Function 14
Highlighting cells if a value is obtained 4
"" + Number = #VALUE! 6
Using multiple IF statements 8
Autofill equations 4
IF and OR nested function 3

Top