Improving Excel Stability

G

Guest

I have sets of data in both Columns A & B. Column C is Column B divided by
Column A. ie... C1=B1/A1. In some cases the data in Column A are equal to
zero. What formula do I use to have C=B/A except when the answer would result
in " #DIV/0! " in which case I would like the cells to be clean as in " ". I
assume this makes the worksheet more stable, correct?
 
G

Gord Dibben

Ken

=IF(A1=0,"",B1/A1)

Note the double quotes with no space between.

You don't want a space, just a blank-looking cell.

The space would most likely give you problems in downstream calculations or when
sorting, filtering and other functions.


Gord Dibben MS Excel MVP
 

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

Having Blank Cells, etc. ? 1
How to determine the stability? 13
Excel not recognizing formula 1
Question on the formula 1
Formuala Question 7
IF(AND condition 1
Importing data from Excel worksheet into Excel template 2
Tracking textual Data changes beween 2 columns & highlight diff nu 1

Top