Forum Discussion
Excel Custom Function
I am trying to write a custom function for rounding a set of data. So that I can reuse it for each form I create and not have to rewrite the whole function. I have tried to use Macros and VBA but fr...
thank you for your help, I am still confused on forming the whole thing.
What can I use in the formula to set reference to the cell selected by the user.
for example, if I want to do simple addition:
=sum(F3+F4)
F3 and F4 were each clicked on the user after starting the formula.
or in your example “x”
For my formula,
I want the user to insert the formula name and select the desired cell they wish to use. What do I write to reference to the current selected cell by the user in:
IF(ISODD(Cell),CEILING(CELL,1),FLOOR(X,1))
=sum(F3+F4)
name as =sum(x+y)
then =my_formula(x,y)
as to
IF(ISODD(Cell),CEILING(CELL,1),FLOOR(X,1))
I am not familiar with formlas,so I do not know what is the exact mean about your function.
Hope other experts come with other suggestions.
name as =sum(x+y)
then =my_formula(x,y)
as to
IF(ISODD(Cell),CEILING(CELL,1),FLOOR(X,1))
I am not familiar with formlas,so I do not know what is the exact mean about your function.
Hope other experts come with other suggestions.