On Thu, 30 Aug 2007 09:22:09 -0400, Tim Di Prinzio wrote:

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.


Place your formula in the new column; then fill down the required number of
rows.


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.


It is not possible. Functions return values, they do not affect other cells.

There are other ways to do what you require, however. You could, for example,
place a number "2" in some blank cell. Edit/Copy that cell. Then select the
cells which need to be modified and Edit/Paste Special/Divide.

This can also be done using a VBA macro.

Thanks in advance for the help.

Regards,

Tim

--ron