I Am Trying To Get The Percentage Of Two Cells By Dividing One Cell Into The Other. Some Of The Time Both Cells Might Have A Zero In Each. Therefore The DIV?

RenDC

» Interview Questions and Answers » Questions » News Feed » Tutorials » rendc.com

Question and Answer:

Home MS Excel

⟩ I am trying to get the percentage of two cells by dividing one cell into the other. Some of the time both cells might have a Zero in each. Therefore the DIV?

This seems like an incredible pain, but I have to use it all of the time.

If your spreadsheet is set up with the numerand in column A, the divisor in B, and in C you are trying to calculate A/B, then you would enter this formula in cell C2:

=IF(B2=0,"NA",A2/B2)

At my job, we use NA to indicate that a number divided by 0 is not applicable. If, as you say, you want a zero there, then you would use this formula:

=IF(B2=0,0,A2/B2)

Is this answer helpful?
0 Yes | 0 No

222 views

More Questions for you:

I am new at this Excel game. How do you figure elapsed time? I have formatted the cells in military time, create a start time column and an end time column and would like to know the difference?

I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return the color of the interior for each cell in a range? I would like to do something like =countif(b1b10, cell("interior","Red"))?

Thanks for your great answer, but this results in my data be backwards; i.e. rather than 12345 I need it to be 54321. Any further thoughts?

I download data which comes to me in a column. I want to use it in a complex sheet that needs data in a row. How can I convert the column data into row data?

How can I enter the symbol for the new Euro currency in my spreadsheet?

I want to add 25 to all of the cells in column A. I do not want a new column, I want to add it right to the cells in column A?

I use a large spreadsheet on a daily basis with 31 worksheets (one for each day of the month). Each worksheet is huge.I would like to insert another sheet in the workbook and insert a button to copy another worksheet to the end of the workbook and then rename the sheet to the correspondingday of the month?

Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?

Where can I find some really good information on how excel treats year 2000 dates? I need simple (and that is what u guys provide)?

Ihave been working with downloaded data and pasting a years worth at a time into a "template" that I want all the resulting spreadsheets to look like. Each years data has approximately the same amount of data in it. Seems each spreadsheet is taking more and more space as I work on them? Any ideas what I have done?

rendc.org

Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."

Quick Links:

Interview Question and Answer Questions Add Questions News-Feed Add Posts HR Hacks Tutorials Profile rendc.com memeph.com

Question and Answer:

Home MS Excel

⟩ I am trying to get the percentage of two cells by dividing one cell into the other. Some of the time both cells might have a Zero in each. Therefore the DIV?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

Home MS Excel

⟩ I am trying to get the percentage of two cells by dividing one cell into the other. Some of the time both cells might have a Zero in each. Therefore the DIV?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: