MS Excel

[AG]

Hi,

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

 

[Gordon]

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.......)

 

[db ´¯`·.. >]

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.

--

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

..