Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV errors
Myabe try trapping for the denominator being blank/containing a zero,
eg: =IF(OR(C1="",C1=0),0,B1/C1) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Sidney Bruce" wrote: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV errors
THANKS TO YOU!
"Sandy Mann" wrote: Use: =IF(C1="","",B1/C1) (The C1="" will also work for blank C1 cells.) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Sidney Bruce" <Sidney wrote in message ... 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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV errors
THANK YOU SO MUCH!
"Max" wrote: Myabe try trapping for the denominator being blank/containing a zero, eg: =IF(OR(C1="",C1=0),0,B1/C1) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Sidney Bruce" wrote: 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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV errors
Thanks for the feedback but Max's formulas is better - I never thought about
C1 holding a zero value. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Sidney Bruce" wrote in message ... THANKS TO YOU! "Sandy Mann" wrote: Use: =IF(C1="","",B1/C1) (The C1="" will also work for blank C1 cells.) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Sidney Bruce" <Sidney wrote in message ... 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! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV errors
Welcome, Sidney.
Take a moment, press the "Yes" button below. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Sidney Bruce" wrote: THANK YOU SO MUCH! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VALUE Errors | Excel Discussion (Misc queries) | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
#DIV/0! Errors | Excel Worksheet Functions | |||
Any errors in this? | Excel Discussion (Misc queries) | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions |