Replace #DIV/0! with other values

Question

May 9, 2008, 12:21 PM

Wonder84lalala

Junior Member

Join Date: Aug 2006

Posts: 39

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.

Answers

May 9, 2008, 01:42 PM	#2

JBeaucaire Software Expert Join Date: Jan 2008 Location: (Call me JB) Bakersfield, CA Posts: 2,283 Pay to call JBeaucaire for advice ($.75/min)	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)

Answer this Question Ask about Spreadsheets

« Previous Question | Next Question »

Question Tools	Search this Question
Show Printable Version Email this Page	Search this Question: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Sponsors

Similar Questions
Question	Asker	Topic	Answers	Last Post
Fundmental values	hwillia5	Government	2	Feb 4, 2008 11:57 AM
Least values	sim0nz12345	Mathematics	4	Feb 2, 2008 09:13 PM
Stock values	frankey222	Finance	3	Oct 23, 2007 11:23 AM
cultural values	khalifi313	Issues & Causes	6	Oct 12, 2007 01:05 PM
future values	kambrose	Finance	1	Nov 30, 2006 08:52 AM



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!