Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default #DIV errors

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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VALUE Errors nastech Excel Discussion (Misc queries) 1 October 10th 07 09:28 AM
Excel Throwing Circular Errors When No Errors Exist MDW Excel Worksheet Functions 1 August 10th 06 02:15 PM
#DIV/0! Errors Cindy Excel Worksheet Functions 5 March 30th 06 05:27 PM
Any errors in this? Frazer Excel Discussion (Misc queries) 0 August 19th 05 08:17 PM
Unresolved Errors in IF Statements - Errors do not show in results Markthepain Excel Worksheet Functions 2 December 3rd 04 08:49 AM


All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"