Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2006

Tip: Looking for answers? Try searching our database.

ERROR.TYPE formula problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tuph - 24 May 2006 04:19 GMT
I am trying to create a formula which will leave a cell empty if it's
dividing by zero, or give me a result if there are numbers in the
referenced cells.  It seems simple enough, but I can't get it to work.

My formula looks like this:

=IF(ERROR.TYPE(E13/E2)>0,"DUD",E13/E2)

If there are no numbers in E13 and/or E2 it returns DUD, but if I put a
number into either or both of E13 and E2, I get a #N/A error.  I have
tried formatting the cells specifically as numbers and as general but
this hasn't made any difference.

HELP!!!:confused:

Trish

Signature

tuph

Biff - 24 May 2006 04:41 GMT
Hi!

Just test for 0:

=IF(E2=0,"",E13/E2)

Biff

> I am trying to create a formula which will leave a cell empty if it's
> dividing by zero, or give me a result if there are numbers in the
[quoted text clipped - 12 lines]
>
> Trish
tuph - 25 May 2006 00:37 GMT
Thanks, Biff!  I knew it had to be simple :rolleyes:

Signature

tuph

Biff - 25 May 2006 02:06 GMT
You're welcome!

Biff

> Thanks, Biff!  I knew it had to be simple :rolleyes:
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.