MS Excel

Hi,

How to get '0' in place of #DIV/0! and #N/A

"AG" <AG@discussions.microsoft.com> wrote in message
news:1A042307-C98E-40F2-B731-3E636C1AAA2E@microsoft.com...
> Hi,
>
> How to get '0' in place of #DIV/0! and #N/A
>

For the first example, you need an IF statement as follows:
Assume A1=1 and B1=0. C1=A1/B1. this gives a value of #DIV/0.
Replace the formula in C1 with "IF(B1=0,0,A1/B1)" without the quotes.
The second value usually results when the formula references a non-existent
cell. (AFAIK - it's been a while.......)

one method could
be using a formula
with the variables like
the below:

if #DIV/0!, then 0

there are other ways
as well, but the above
gives you a general idea.

--

db ·´¯`·.¸. , . .·´¯`·..><)))º>`·.¸¸.·´¯`·.¸.·´¯` ·...¸><)))º>¸.
><)))º>·´¯`·.¸. , . .·´¯`·.. ><)))º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><))) º>


..


"AG" <AG@discussions.microsoft.com> wrote in message
news:1A042307-C98E-40F2-B731-3E636C1AAA2E@microsoft.com...
> Hi,
>
> How to get '0' in place of #DIV/0! and #N/A
>
>
>
>