Getting rid of !ZeroDivide error

[mamaluw]

All I want to do is divide cell B5 by C5, skip D5 which has anothe
number in it that is not relevant to my formula, and have the answe
appear in E5. I keep getting !ZeroDivide error. What am I doin
wrong? It should be so simple, but I am missing something

 

[{*BoB*} OZZIE]

I may be wrong but I still don't think you can divide by
zero - can't remember when in grade school I learned that
one, though with the new math it could have changed


If C5 is blank or zero, then you will get that message

Starting with the "=" sign try this in E5
=IF(C5<>0,+B5/C5,"0")


FYI - you could put whatever, as in text. between the
quotes in the formula and it will show up. Keep in mind if
you put text then you will get an error if you use a
mathematical formula that references that cell (E5) since
you can't add an alpha to a numeric.

HTH..

 

[mamaluw]

C5 is not blank or zero. I also know from grade school you canno
divide by zero. C5 is 15, B5 is 164, skip D5 which is 8, and ente
answer in E5. Your tip gave me a syntax error. Any other tips

 

[mamaluw]

C5 is not blank or zero. I also know from grade school you canno
divide by zero. C5 is 15, B5 is 164, skip D5 which is 8, and ente
answer in E5. Your tip gave me a syntax error. Any other tips

 

[firefytr]

Try this in cell E5:

=IF(N(C5),B5/C5,0)

Help any