Formula as User Defined Function

[Guest]

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

 

[Frank Kabel]

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

 

[Guest]

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]

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