What IF - formula question
 

I need help with an 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
 

I think you mean something like:

=IF(G43=0,"",H43/G43)

Hope this helps.

Pete


Gene wrote:
I need help with an 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


"Pete_UK" wrote:

I think you mean something like:

=IF(G43=0,"",H43/G43)

Hope this helps.

Pete


Gene wrote:
I need help with an 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
 

If G43 does equal zero, then you will get #DIV/0! because you are
trying to divide by zero - the formula I suggested intercepts this and
returns a blank instead. You can't get any + & - results when G43 = 0.
Perhaps you need to re-phrase the problem and what it is you are trying
to achieve.

Pete

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


"Pete_UK" wrote:

I think you mean something like:

=IF(G43=0,"",H43/G43)

Hope this helps.

Pete


Gene wrote:
I need help with an 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
 

when i create the formula below and drag it down many rows there are rows
that have no info or words in the rows. these rows create a #div/0! result.
those are the rows that i want blank. the dozens of other rows with figures
may have a result in the positive or negative in the formula result.

if i am not clear i will start over completely. thanks Pete_UK for taking
the time.
--
Gene


"Pete_UK" wrote:

If G43 does equal zero, then you will get #DIV/0! because you are
trying to divide by zero - the formula I suggested intercepts this and
returns a blank instead. You can't get any + & - results when G43 = 0.
Perhaps you need to re-phrase the problem and what it is you are trying
to achieve.

Pete

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


"Pete_UK" wrote:

I think you mean something like:

=IF(G43=0,"",H43/G43)

Hope this helps.

Pete


Gene wrote:
I need help with an 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
 

Have you tried Pete's suggestion? It works for me.

=IF(G43=0,"",H43/G43)


"Gene" wrote in message
...
when i create the formula below and drag it down many rows there are rows
that have no info or words in the rows. these rows create a #div/0!
result.
those are the rows that i want blank. the dozens of other rows with
figures
may have a result in the positive or negative in the formula result.

if i am not clear i will start over completely. thanks Pete_UK for taking
the time.
--
Gene


"Pete_UK" wrote:

If G43 does equal zero, then you will get #DIV/0! because you are
trying to divide by zero - the formula I suggested intercepts this and
returns a blank instead. You can't get any + & - results when G43 = 0.
Perhaps you need to re-phrase the problem and what it is you are trying
to achieve.

Pete

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


"Pete_UK" wrote:

I think you mean something like:

=IF(G43=0,"",H43/G43)

Hope this helps.

Pete


Gene wrote:
I need help with an 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
 

Yes it works for me too. I had tried it several times but was entering the
data in a wrong column. Thanks David & Pete.

I am so impressed with assistance by many the 3-4 times I've posted here.
Again thanks.
Gene
--
Gene


"David F Cox" wrote:

Have you tried Pete's suggestion? It works for me.

=IF(G43=0,"",H43/G43)


"Gene" wrote in message
...
when i create the formula below and drag it down many rows there are rows
that have no info or words in the rows. these rows create a #div/0!
result.
those are the rows that i want blank. the dozens of other rows with
figures
may have a result in the positive or negative in the formula result.

if i am not clear i will start over completely. thanks Pete_UK for taking
the time.
--
Gene


"Pete_UK" wrote:

If G43 does equal zero, then you will get #DIV/0! because you are
trying to divide by zero - the formula I suggested intercepts this and
returns a blank instead. You can't get any + & - results when G43 = 0.
Perhaps you need to re-phrase the problem and what it is you are trying
to achieve.

Pete

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


"Pete_UK" wrote:

I think you mean something like:

=IF(G43=0,"",H43/G43)

Hope this helps.

Pete


Gene wrote:
I need help with an 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
 

You're welcome, Gene - keep posting!

Pete

Gene wrote:
Yes it works for me too. I had tried it several times but was entering the
data in a wrong column. Thanks David & Pete.

I am so impressed with assistance by many the 3-4 times I've posted here.
Again thanks.
Gene
--
Gene


"David F Cox" wrote:

Have you tried Pete's suggestion? It works for me.

=IF(G43=0,"",H43/G43)


"Gene" wrote in message
...
when i create the formula below and drag it down many rows there are rows
that have no info or words in the rows. these rows create a #div/0!
result.
those are the rows that i want blank. the dozens of other rows with
figures
may have a result in the positive or negative in the formula result.

if i am not clear i will start over completely. thanks Pete_UK for taking
the time.
--
Gene


"Pete_UK" wrote:

If G43 does equal zero, then you will get #DIV/0! because you are
trying to divide by zero - the formula I suggested intercepts this and
returns a blank instead. You can't get any + & - results when G43 = 0.
Perhaps you need to re-phrase the problem and what it is you are trying
to achieve.

Pete

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


"Pete_UK" wrote:

I think you mean something like:

=IF(G43=0,"",H43/G43)

Hope this helps.

Pete


Gene wrote:
I need help with an 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