Divided by zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I have two cells e.g. a1 & b1 and c1 contains the formula =a1/b1, if b1
equals to 0 then i need that formula returns 0 in c1 instead of #DIV/0!

Plz help

Regards

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

Hassan said:
Hi All,

I have two cells e.g. a1 & b1 and c1 contains the formula =a1/b1, if b1
equals to 0 then i need that formula returns 0 in c1 instead of #DIV/0!

Plz help

Regards

Hassan
Click to expand...
 

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

Time Calculations Help 4
Re. Conditional formating of adjacent cells but down a column 0
A data validation question 1
Cells with varying number of lines 1
Putting Formula in all cells give Circular Reference. Please help 7
Conditional formatting based on numbers in columns 5
Tranfer data from Excel to word (Docx) via VBA in Excel 5
Excel IF function in excel 2

Back
Top