#DIV errors

[Sidney Bruce]

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]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Max]

Myabe try trapping for the denominator being blank/containing a zero,
eg: =IF(OR(C1="",C1=0),0,B1/C1)

 

[Sidney Bruce]

THANKS TO YOU!

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sidney Bruce]

THANK YOU SO MUCH!

Myabe try trapping for the denominator being blank/containing a zero,
eg: =IF(OR(C1="",C1=0),0,B1/C1)

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Max]

Welcome, Sidney.
Take a moment, press the "Yes" button below.