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!