#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!

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!

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!

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!

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!

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!

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!