I was wondering if anyone could point me in the right direction on a few
questions I have. I would like to evaluate the value in a cell in a
column and if it is within a certain range write a value to a new
column. I would like to do this for and entire column? Meaning write the
function once and have it work for the whole column.

Also is it possible to have a formula change the value of a cell and
write the results back to the same cell. i.e n1 has a value of 25. the
value I really need is 25/2. This is on imported data. I prefer not to
write to another column. Basically as the data is imported or inputted
the calc takes place.

Thanks in advance for the help.

Regards,

Tim