How to automatically populate using Macro

  • Thread starter Thread starter ICSAnalyst
  • Start date Start date
I

ICSAnalyst

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 (e-mail address removed)
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional listbox cell populating 4
VBA set thick borders around non empty cells in range 0
Strip out certain rows that have merged cells 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Transfer array element offset value to a matched value 3
Cell Population 6
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4

Back
Top