I want a code that can automatically populate a column wich is (E).
want the column to be dividing column A/ Column C. And if there isn'
anything in Column A or C.. then the column cell =0 . And if the answe
is N/A- Then the column cell equals -

Thanks, Please email me

--
ICSAnalys
-----------------------------------------------------------------------
ICSAnalyst's Profile: http://www.excelforum.com/member.php...fo&userid=1509
View this thread: http://www.excelforum.com/showthread.php?threadid=26726

Hi
do you need a macro or would a formula do as well?. For the latter use
=IF(COUNT(A1,C1)=2,A1/C1,0)

Note: Does not take care of C1=0 and I'm not sure what you mean with
N/A?

--
Regards
Frank Kabel
Frankfurt, Germany

"ICSAnalyst" schrieb im
Newsbeitrag ...

I want a code that can automatically populate a column wich is (E). I
want the column to be dividing column A/ Column C. And if there isn't
anything in Column A or C.. then the column cell =0 . And if the
answer
is N/A- Then the column cell equals -

Thanks, Please email me


--
ICSAnalyst
---------------------------------------------------------------------
---
ICSAnalyst's Profile:
http://www.excelforum.com/member.php...o&userid=15095
View this thread:
http://www.excelforum.com/showthread...hreadid=267266

hi.
try this formula
=IF(A3="",0,IF(C3="",0,IF(C3=0,0,A3/C3)))

-----Original Message-----

I want a code that can automatically populate a column
wich is (E). I
want the column to be dividing column A/ Column C. And if
there isn't
anything in Column A or C.. then the column cell =0 . And
if the answer
is N/A- Then the column cell equals -

Thanks, Please email me


--
ICSAnalyst
----------------------------------------------------------
--------------
ICSAnalyst's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=15095
View this thread:
http://www.excelforum.com/showthread...hreadid=267266

.