what IF - formula question
 

=IF(G43=0,"",sum(hH43/G32)).
This will avoid division by zero so #DIV/0 will not appear.
Also if you want to drag the formula, I think you should use fixed reference
($G$32) instead of relative reference (G43).

"Gene" wrote in message
...
Sorry for the multiple posts. Twice a window opened when I clicked post
and
said there was an error and it did not post. again sorry.
--
Gene


"Gene" wrote:

What IF formula question. My cell has a formula in it =sum(H43/G43). I
want this cell blank €œ€� If the result is not a percentage (the cell has
been
formatted to be a %). When I drag the formula to many other cells some
of
them are #DIV/O! and I want those cells to be blank.

I cant figure out how to do this. Thanks for your time and help!

--
Gene

what IF - formula question
 

What IF formula question. My cell has a formula in it =sum(H43/G43). I
want this cell blank €œ€� If the result is not a percentage (the cell has been
formatted to be a %). When I drag the formula to many other cells some of
them are #DIV/O! and I want those cells to be blank.

I cant figure out how to do this. Thanks for your time and help!

--
Gene

what IF - formula question
 

Sorry for the multiple posts. Twice a window opened when I clicked post and
said there was an error and it did not post. again sorry.
--
Gene


"Gene" wrote:

What IF formula question. My cell has a formula in it =sum(H43/G43). I
want this cell blank €œ€� If the result is not a percentage (the cell has been
formatted to be a %). When I drag the formula to many other cells some of
them are #DIV/O! and I want those cells to be blank.

I cant figure out how to do this. Thanks for your time and help!

--
Gene

what IF - formula question
 

But the SUM function is not needed
=IF(G43=0,"",H43/G32).

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rasoul Khoshravan" wrote in message
...
=IF(G43=0,"",sum(hH43/G32)).
This will avoid division by zero so #DIV/0 will not appear.
Also if you want to drag the formula, I think you should use fixed
reference ($G$32) instead of relative reference (G43).

"Gene" wrote in message
...
Sorry for the multiple posts. Twice a window opened when I clicked post
and
said there was an error and it did not post. again sorry.
--
Gene


"Gene" wrote:

What IF formula question. My cell has a formula in it =sum(H43/G43).
I
want this cell blank "" If the result is not a percentage (the cell has
been
formatted to be a %). When I drag the formula to many other cells some
of
them are #DIV/O! and I want those cells to be blank.

I can't figure out how to do this. Thanks for your time and help!

--
Gene

what IF - formula question
 

except I need the G43=0 to include + & - results. I only need #div/0! to be
shown as nothing.

--
Gene


"Bernard Liengme" wrote:

But the SUM function is not needed
=IF(G43=0,"",H43/G32).

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rasoul Khoshravan" wrote in message
...
=IF(G43=0,"",sum(hH43/G32)).
This will avoid division by zero so #DIV/0 will not appear.
Also if you want to drag the formula, I think you should use fixed
reference ($G$32) instead of relative reference (G43).

"Gene" wrote in message
...
Sorry for the multiple posts. Twice a window opened when I clicked post
and
said there was an error and it did not post. again sorry.
--
Gene


"Gene" wrote:

What IF formula question. My cell has a formula in it =sum(H43/G43).
I
want this cell blank "" If the result is not a percentage (the cell has
been
formatted to be a %). When I drag the formula to many other cells some
of
them are #DIV/O! and I want those cells to be blank.

I can't figure out how to do this. Thanks for your time and help!

--
Gene