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