I get #DIV/0!
 

I am trying to get numbers in column I to reflect 0 if H$14 adds up to 0.

The cell H$14 is actually =SUM(H7:H13)

So, in cell I7 I enter =IF(H$14="0","0",H7/H$14)

However, I get #DIV/0! in I7 even though H$14 sums to 0. I thought that's
the case is because H$14 is not actually 0 but a formula, but that's still
the case even if I replace the formula with a 0.

Help!

Thanks.

Jack

I get #DIV/0!
 

Hi Jack
Take the inverted comma's out the formula

=IF(H$14=0,0,H7/H$14)

HTH
Michael

"Jack" wrote:

I am trying to get numbers in column I to reflect 0 if H$14 adds up to 0.

The cell H$14 is actually =SUM(H7:H13)

So, in cell I7 I enter =IF(H$14="0","0",H7/H$14)

However, I get #DIV/0! in I7 even though H$14 sums to 0. I thought that's
the case is because H$14 is not actually 0 but a formula, but that's still
the case even if I replace the formula with a 0.

Help!

Thanks.

Jack

I get #DIV/0!
 

Michael --

That did it!

I guess you use the quotes only if referring to text.

Thanks!

Jack




"Michael M" wrote in message
...
Hi Jack
Take the inverted comma's out the formula

=IF(H$14=0,0,H7/H$14)

HTH
Michael

"Jack" wrote:

I am trying to get numbers in column I to reflect 0 if H$14 adds up to 0.

The cell H$14 is actually =SUM(H7:H13)

So, in cell I7 I enter =IF(H$14="0","0",H7/H$14)

However, I get #DIV/0! in I7 even though H$14 sums to 0. I thought that's
the case is because H$14 is not actually 0 but a formula, but that's still
the case even if I replace the formula with a 0.

Help!

Thanks.

Jack

I get #DIV/0!
 

That's correct.....Quotes for text, nothing for numbers

Michael M

"Jack" wrote:

Michael --

That did it!

I guess you use the quotes only if referring to text.

Thanks!

Jack




"Michael M" wrote in message
...
Hi Jack
Take the inverted comma's out the formula

=IF(H$14=0,0,H7/H$14)

HTH
Michael

"Jack" wrote:

I am trying to get numbers in column I to reflect 0 if H$14 adds up to 0.

The cell H$14 is actually =SUM(H7:H13)

So, in cell I7 I enter =IF(H$14="0","0",H7/H$14)

However, I get #DIV/0! in I7 even though H$14 sums to 0. I thought that's
the case is because H$14 is not actually 0 but a formula, but that's still
the case even if I replace the formula with a 0.

Help!

Thanks.

Jack