Prev: Converting digits to characters (123 to ABC)
Next: Differences between VBA in Excel 2007-2010
From: Robert Crandal on 18 May 2010 04:08
I am using the following formula in one of my cells: "=C1 / D2".
The problem with this formula is that the result will be "#DIV/0!"
if cell D2 contains no data.

Can I somehow fix my formula so it does NOT return any value
if either C1 or D2 is empty? I just want to avoid situations when
the outuput of my formula is "#DIV/0!" or "#Value#" because it
just doesn't look pretty to me, hahah!

Thank you!


From: jkrons on 18 May 2010 05:16
Try =IF(ISNA(C1/D2;"";C1/D2)

Jan

On 18 Maj, 10:08, "Robert Crandal" <nob...(a)gmail.com> wrote:
> I am using the following formula in one of my cells: "=C1 / D2".
> The problem with this formula is that the result will be "#DIV/0!"
> if cell D2 contains no data.
>
> Can I somehow fix my formula so it does NOT return any value
> if either C1 or D2 is empty?   I just want to avoid situations when
> the outuput of my formula is "#DIV/0!" or "#Value#" because it
> just doesn't look pretty to me, hahah!
>
> Thank you!

From: jkrons on 18 May 2010 05:18
Actually

=IF(ISERROR(C1/D2;"";C1/D2)

is better

On 18 Maj, 11:16, jkrons <j...(a)knord.dk> wrote:
> Try =IF(ISNA(C1/D2;"";C1/D2)
>
> Jan
>
> On 18 Maj, 10:08, "Robert Crandal" <nob...(a)gmail.com> wrote:
>
>
>
> > I am using the following formula in one of my cells: "=C1 / D2".
> > The problem with this formula is that the result will be "#DIV/0!"
> > if cell D2 contains no data.
>
> > Can I somehow fix my formula so it does NOT return any value
> > if either C1 or D2 is empty?   I just want to avoid situations when
> > the outuput of my formula is "#DIV/0!" or "#Value#" because it
> > just doesn't look pretty to me, hahah!
>
> > Thank you!- Skjul tekst i anførselstegn -
>
> - Vis tekst i anførselstegn -

From: Peter T on 18 May 2010 05:33
Another way but only if all users have 2007+

=IFERROR(A1/B1,"")

in 97-2003 use ISERROR as suggested by jkrons

Regards,
Peter T

"jkrons" <jkr(a)knord.dk> wrote in message
news:866dc834-28f7-43b9-9961-1a60975d64b3(a)o12g2000vba.googlegroups.com...
Actually

=IF(ISERROR(C1/D2;"";C1/D2)

is better

On 18 Maj, 11:16, jkrons <j...(a)knord.dk> wrote:
> Try =IF(ISNA(C1/D2;"";C1/D2)
>
> Jan
>
> On 18 Maj, 10:08, "Robert Crandal" <nob...(a)gmail.com> wrote:
>
>
>
> > I am using the following formula in one of my cells: "=C1 / D2".
> > The problem with this formula is that the result will be "#DIV/0!"
> > if cell D2 contains no data.
>
> > Can I somehow fix my formula so it does NOT return any value
> > if either C1 or D2 is empty? I just want to avoid situations when
> > the outuput of my formula is "#DIV/0!" or "#Value#" because it
> > just doesn't look pretty to me, hahah!
>
> > Thank you!- Skjul tekst i anf�rselstegn -
>
> - Vis tekst i anf�rselstegn -


From: Mike H on 18 May 2010 05:48
Robert,

This will return a blank cell unless both cells have a number in

=IF(COUNT(C1,D2)=2,C1/D2,"")

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Robert Crandal" wrote:

> I am using the following formula in one of my cells: "=C1 / D2".
> The problem with this formula is that the result will be "#DIV/0!"
> if cell D2 contains no data.
>
> Can I somehow fix my formula so it does NOT return any value
> if either C1 or D2 is empty? I just want to avoid situations when
> the outuput of my formula is "#DIV/0!" or "#Value#" because it
> just doesn't look pretty to me, hahah!
>
> Thank you!
>
>
> .
>
 | 
Pages: 1
Prev: Converting digits to characters (123 to ABC)
Next: Differences between VBA in Excel 2007-2010