Divide by zero error

		Microsoft Office Forums > Microsoft Excel > Excel
Divide by zero error

FAQ

Mark Forums Read

Thread Tools

Display Modes

08-16-2016, 04:53 AM

Pecoflyer

Windows 7 64bit Divide by zero error

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Try
=or(iserror((A3+$K$2)/(B3-2)),((A3+$K$2)/(B3-2))<0)

as CF ( the SUM function you used is redundant)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Divide Number between cells	s7y	Excel Programming	2	01-15-2014 12:59 PM
Hide Divide by Zero Option?	SteveBump	Excel	4	12-15-2013 09:53 PM
how to divide into group	tomlam	Excel Programming	2	05-20-2013 09:46 PM
formula divide by serio error	vthomeschoolmom	Excel	1	04-18-2012 02:29 PM
Divide by zero error	doublejoy	Excel	1	08-22-2009 03:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:05 AM.