<<< 0 or blank in C7 returns ""

Not in my XL97 Gord.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I cannot replicate.

100 in B7

10 in C7

Formula =IF(C7="","",(B7/2/C7)) in D7 returns 5

0 or blank in C7 returns ""


Gord


On Sun, 2 Dec 2007 16:34:00 -0800, LowRider

wrote:

Ok I have entered the formula you provided, BTW Thank You, but I am still
getting the #DIV/0! Error in Column D where this formula is being placed.

Thanks again for the help.

Ron



"Gord Dibben" wrote:

=IF(C7="","",(B7/2/C7))

You don't need the SUM function for your example.


Gord Dibben MS Excel MVP

On Sun, 2 Dec 2007 15:38:00 -0800, LowRider

wrote:

Hi All,

Ok I have created a Workbook using 3 pages Tab1=RPM_Main, Tab2=PPS and
Tab3=Laps.

I have the info from cells on Tab2 and Tab3 going to Tab1, However on
Tab1=RPM_Main in certain cells there is nothing to compute and is
given me an
error #DIV/0!

The Formula I am using is In Column "D" is =SUM(B7/2/C7). Now the
Column
"C" may have a 0=ZERO brought over from the Tab2 worksheet as there is
no
data computed and it is giving me the #DIV/0! error. How can I change
this
formula to do away with that Error? I have some other issues with
this
Spreadsheet and will discuss each one once I get other issues resolved
to
help keep my sanity, LOL.

Thanks Much In advance.

Ron