用函数添加两个数字-Addingtwonumberswithafunction

3  

You define your input variables in the FUNCTION declaration line, not above it. I would recommend the vartype DOUBLE for whole numbers and decimals.

您可以在FUNCTION声明行中定义输入变量,而不是在它上面。我建议使用整数和小数的vartype DOUBLE。

Function ADDTWO(ByVal x As Double,ByVal  y As Double) As Double
    ADDTWO = x + y
End Function

Now this function can be used in a cell as:

现在这个函数可以在单元格中用作:

=ADDTWO(3, 6)
or
=ADDTWO(A2, B7)

= ADDTWO(3,6)或= ADDTWO(A2,B7)

It can also be used in VBA.

它也可以用在VBA中。

Of course, the SUM() function does this same thing, so....I presume this is a learning exercise.

当然,SUM()函数也做同样的事情,所以....我认为这是一个学习练习。

2  

As far as working with any two numbers, try the Variant data type instead of Integer. Not sure what you mean by manually inputting the values - are you talking about getting them from the worksheet?

至于使用任何两个数字,请尝试Variant数据类型而不是Integer。通过手动输入值不确定您的意思 - 您是在谈论从工作表中获取它们吗?