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 / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

#DIV errors

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sidney Bruce - 24 May 2008 20:44 GMT
Someone please help ! Have looked everywhere.

I have created a worksheet where the user enters an item and a price and the
worksheet calcs the unit price.  Like this:

A                        B                  C                    D
Item                   Price              Units              Price per Unit
Cheese               $ 10.00          2                    =b1/c1      so $
5.00 is answered

That's fine as long as there is any entry, with no entry say onthe 2nd line
it looks like this

A                        B                  C                    D
Item                   Price              Units              Price per Unit
Cheese               $ 10.00          2                    =b1/c1      so $
5.00 is answered
blank                  blank             blank               # DIV/0#

It is this error (#DIV/0!) thats my issue.  The answer (when an entry is
made) the $ 5.00 is posted into aother worksheet...but the #DIV errors are
causing subsequent #DIV errors when I try to say...add the colum or do
anything else with that group of data.

I need the user to be able to enter multiple data, but I need to be able to
make the calcs without comming up with the #DIV when the user leaves the line
blank.

Please Help!
Sandy Mann - 24 May 2008 20:49 GMT
Use:

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

(The C1="" will also work for blank C1 cells.)

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Someone please help ! Have looked everywhere.
>
[quoted text clipped - 33 lines]
>
> Please Help!
Sidney Bruce - 24 May 2008 21:23 GMT
THANKS TO YOU!

> Use:
>
[quoted text clipped - 39 lines]
> >
> > Please Help!
Sandy Mann - 24 May 2008 23:11 GMT
Thanks for the feedback but Max's formulas is better - I never thought about
C1 holding a zero value.

Signature

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> THANKS TO YOU!
>
[quoted text clipped - 48 lines]
>> >
>> > Please Help!
Max - 24 May 2008 20:54 GMT
Myabe try trapping for the denominator being blank/containing a zero,
eg: =IF(OR(C1="",C1=0),0,B1/C1)
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Someone please help ! Have looked everywhere.
>
[quoted text clipped - 25 lines]
>
> Please Help!
Sidney Bruce - 24 May 2008 21:23 GMT
THANK YOU SO MUCH!

> Myabe try trapping for the denominator being blank/containing a zero,
> eg: =IF(OR(C1="",C1=0),0,B1/C1)
[quoted text clipped - 27 lines]
> >
> > Please Help!
Max - 24 May 2008 23:55 GMT
Welcome, Sidney.
Take a moment, press the "Yes" button below.
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> THANK YOU SO MUCH!
 
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.