Dividing by zero

Kathy · Sep 17, 2003

How do I devise a formula that will display a zero when
dividing by zero without getting the error message
#DIV/0#? The original formula is asking Excel to take the
difference of the current goal minus the actual and then
divide it by the achieved goal from the previous year to
give a percentage. Thanks in advance.

Kathy

Ron de Bruin · Sep 17, 2003

Use the If function

=IF(A1="","",B1/A1)

Milana · Sep 17, 2003

Try this
=if(iserror(YOUR FORMULA),"0",(YOUR FORMULA))

Divide by Zero	3	Jul 9, 2004
Excel - IF Formula and #DIV0!	2	May 25, 2005
two problems with excel 2003	3	Nov 18, 2004
formula question, IF/AND	4	Nov 10, 2004
Divison by 0	4	Apr 26, 2005
Using the IF Function effectively	3	Dec 4, 2003
FORMULA	2	Apr 5, 2004
Dividing by zero	1	Jan 7, 2005

Dividing by zero

Kathy

Ron de Bruin

Milana

Ask a Question

Similar Threads