Ask Experts Questions for FREE Help !
Ask
    Wonder84lalala's Avatar
    Wonder84lalala Posts: 41, Reputation: 1
    Junior Member
    		  
    #1

    May 9, 2008, 01:21 PM
    Replace #DIV/0! With other values
    Is it possible to replace the output from #DIV/0! To 0 or other random values within a cell?

    I tried using if statement, but it won't let me:

    =IF(A1=#DIV/0! 0)

    Thanks for your help.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    May 9, 2008, 02:42 PM
    Say you want to divide the value in A1 by the value in A2. That formula is simple:
    Code:
    =a1/a2
    The problem is that if the value in A2 is zero, it doesn't work, thus the error you're seeing, so check that cell first. There are couple of ways to do that.
    Code:
    =IF(ISERROR(A1/A2),0,A1/A2)
    or
=IF(A2=0,0,A1/A2)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Stock values [ 4 Answers ]

Stock Values. Integrated Potato Chips paid a $1 per share dividend yesterday. You expect the dividend to grow steadily at a rate of 4 percent per year. a. What is the expected dividend in each of the next 3 years? b. If the discount rate for the stock is 12 percent, at what price will the...

Fundmental values [ 3 Answers ]

Conflicts over fundamental values a. are inherent in any political system b. would disappear if citizens knew more about their political system c. are common in autocratic or nondemocratic political systems d. can be eliminated through democratic reforms I think it is C am I rights?

Least values [ 4 Answers ]

What does the least value of f(x)=5-2cos(x) mean? Thanks

Cultural values [ 6 Answers ]

hi, I'supposed to teach my students to talk about personal values which should guide them in life . But I'm a bit lost as I'dont how proceed.Thanks for help

Future values [ 1 Answers ]

compute the future value of $100 cash flow for 8% interest and for 10 years?

View more questions Search