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

[mick25]

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). This gives me 0 on row 2. I've also tried =if(a3/b3=-,"",A3/B3), and this gives me #DIV/0! on row 3.

For example, I would like C1 to be .02, C2 to be blank, and C3 to be blank. Any help you can provide on this I would greatly appreciate!

 

[Firefly2012]

Hi MIck

You almost had it right the first time:

=if(or(iserror(A1/B1),A1=0),"",A1/B1)

 

[mick25]

Huh, thanks Firefly! My boss has always said I'm just smart enough to be dangerous...