zero cells equal blank

  1. J

    How to remove text from chart when value is zero??

    Hallo everybody, My question relates to a simple bar-chart, where I have values from the past week’s sales performance for all our products. Ex: <tbody> Week 45 Sales Banana 5 Apple 0 Orange 10 </tbody> How can I make the text disappear when the value is zero – and make the chart...
  2. M

    Dividing series of cells, some with zero amounts, without giving error or 0

    Hi, I have a worksheet with a series of numbers like so: A1 - $36.10 B1 - $1,835.25 A2 - B2 - $1,321.25 A3 - B3 - I would like to divide column A by column B, and either get a number (not 0) or have the cell be blank. I've tried =if(or(iserror(A1/B1),B1=0),"",A1/B1)...
    • mick25
    • Thread
    • #div/0! error if/or zero cells equal blank
    • Replies: 2
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top