I have been copying down the formulas and then copying and pasting the
value, but I'm doing this for 4 columns of formulas over about 2000 rows. I
was looking for an easier solution as I have to recalculate the coumns
sometimes.

Thanks,

Esther

"Frank Kabel" wrote:

Hi
why do you want a UDF for this?. will slow down your Excel sheet and
won't be much simpler? Just copy this formula down

--
Regards
Frank Kabel
Frankfurt, Germany

"EstherJ" schrieb im Newsbeitrag
...
How do I get the following formula to work as a user defined
function.

=if(a1=9,(b1+1),b1) and paste the result in cell c1

It would then have to work in row 2, 3 etc referering to those rows.

Thank you,

Esther