DIV/0 error

[Kidmon]

I am using excel 2007

I need to divide numbers from cells that sometimes contain blank cells.
I am using =(B3/B5) and it works until if finds a blank cell. Then I get the dreded DIV/0 ERROR.

I have tried to use =IFERROR(QUOTIENT(B2,B5),"") and it works but I need to see the complete number. This returns something like 6, but I need to see 6.66 to be more acurate.

What is a simple way to write the formula?

Thanx for your help

 

[Jonmo1]

Try

=IF(B5="","",B3/B5)

 

[Kidmon]

Thank you for your help.
I tried your formula and it still return DIV/0 error. I am sure I have not eplained it clearly for the forum. I have created a screen shot in a hope of making a better picture to understand my error. Please check it out. Thank you again, I really appreciate the help I have received from this forum.

 

[Jonmo1]

In your last post, it looks like the cell's contain 0, not blank...

=IF(B5=0,"",B3/B5)

 

[T. Valko]

I am using excel 2007

I need to divide numbers from cells that sometimes contain blank cells.
I am using =(B3/B5) and it works until if finds a blank cell. Then I get the dreded DIV/0 ERROR.

I have tried to use =IFERROR(QUOTIENT(B2,B5),"") and it works but I need to see the complete number. This returns something like 6, but I need to see 6.66 to be more acurate.

What is a simple way to write the formula?

Thanx for your help

See your other thread:

http://www.mrexcel.com/forum/showthread.php?t=616970

 

[Kidmon]

Thank you. Of course 0 is not blank. Duuuuuu, I should have thunk it. Learning to think in Excel is a new language for me.

By the way, what do I do if the cells contain a #VALUE ERROR because B5 contains a number before B3 is populated?
Thanx again, This forum is wonderful.

 

[Scott Huish]

=if(and(b5,count(b3,b5)=2),b3/b5,"")