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

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

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

Hi
a UDF has to be copied in the same way. You may consider using a macro
inserting the formulas but normally copy/paste should be easier. e.g.
- insert the formula in the first row
- double click on the lower right corner of this formula cell. Excel
should copy the formula for all rows automatically

--
Regards
Frank Kabel
Frankfurt, Germany


EstherJ wrote:
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