Curing #DIV/0!????

[Simon Lloyd]

Hi,

Can anyone tell me how to cure the div/o fault on my spread sheet when no value is found......just to tidy things up?

Thanks,

Simon

[NickHK]

Simon,
Either test for the 0 value first [=IF(Whatever=0,,,,,]
or test the result for the error [=IF(ISERROR(Whatever),,,,

NickHK

"Simon Lloyd" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> Can anyone tell me how to cure the div/o fault on my spread sheet when
> no value is found......just to tidy things up?
>
> Thanks,
>
> Simon
>
>
> --
> Simon Lloyd
> ------------------------------------------------------------------------
> Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
> View this thread: http://www.excelforum.com/showthread...hreadid=396012
>

[Rowan]

Use iserror eg

=if(iserror(a1/b1),"",a1/b1)

Regards
Rowan

"Simon Lloyd" wrote:

>
> Hi,
>
> Can anyone tell me how to cure the div/o fault on my spread sheet when
> no value is found......just to tidy things up?
>
> Thanks,
>
> Simon
>
>
> --
> Simon Lloyd
> ------------------------------------------------------------------------
> Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
> View this thread: http://www.excelforum.com/showthread...hreadid=396012
>
>

[galimi]

=if(denom=0,"Zero Denominator",numer/denom)

Where denom is the range of the denominator and numer is the range of the
numerator
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Simon Lloyd" wrote:

>
> Hi,
>
> Can anyone tell me how to cure the div/o fault on my spread sheet when
> no value is found......just to tidy things up?
>
> Thanks,
>
> Simon
>
>
> --
> Simon Lloyd
> ------------------------------------------------------------------------
> Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
> View this thread: http://www.excelforum.com/showthread...hreadid=396012
>
>

[Simon Lloyd]

Thanks for your replies, Rowan's reply seemed the most straight forward (i'm on nights and brain isnt working too well!) the only problem i have now is that if i use that formula all my percentages now show as a decimal i.e 3% is now 0.0314.

Is there a tweak for this?

Thanks again,

Simon.

[Rowan]

Have you formatted the cells as Percentage?

"Simon Lloyd" wrote:

>
> Thanks for your replies, Rowan's reply seemed the most straight forward
> (i'm on nights and brain isnt working too well!) the only problem i
> have now is that if i use that formula all my percentages now show as a
> decimal i.e 3% is now 0.0314.
>
> Is there a tweak for this?
>
> Thanks again,
>
> Simon.
>
>
> --
> Simon Lloyd
> ------------------------------------------------------------------------
> Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
> View this thread: http://www.excelforum.com/showthread...hreadid=396012
>
>

[[email protected]]

If it is simply to pretty up the look rather than to remove the fault try
a conditional format
formula is =ISERROR(A1) and set the format so the text matches the
background colour.

hth RES

[Simon Lloyd]

Sorry to all!

As i said brain isnt working!!! ..........format cells!........it was a no brainer!

Simon