Replace #DIV/0! with other values

Question

May 9, 2008, 01:21 PM

Wonder84lalala

Junior Member

Join Date: Aug 2006

Posts: 44

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, 02:42 PM	#2

JBeaucaire Software Expert Join Date: Jan 2008 Location: (Call me JB) Bakersfield, CA Posts: 4,697 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)

Similar Sponsors

Thread Tools

Show Printable Version

Email this Page

Similar Threads

Fundmental values
(2 replies)

Least values
(4 replies)

Stock values
(3 replies)

cultural values
(6 replies)

future values
(1 replies)

Search this Thread

Advanced Search

Bookmarks



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!