Formula as User Defined Function
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
|