I'm new at creating functions and I can't figure out why this doesn't work.
I created the following function:
Function functiamea(A As Double, B As Double, C As Double) As Double
If (A > 30 And B <= 30 And C <= 30) Then
functiamea = Average(J16, J17)
If (A > 30 And B <= 30 And C > 30) Then
functiamea = Average(J16, J17)
If (A > 30 And B > 30 And C <= 30) Then
functiamea = Average(J15, J17)
If (A <= 30 And B <= 30 And C > 30) Then
functiamea = Average(J15, J16)
If (A <= 30 And B > 30 And C > 30) Then
functiamea = Average(J15, J16)
If (A <= 30 And B > 30 And C <= 30) Then
functiamea = Average(J15, J17)
If (A <= 30 And B <= 30 And C <= 30) Then
functiamea = Average(J15, J16, J17)
Else
functiamea = "TALK TO THE BOSS"
End Function
When I try to insert the function in the spreadsheet I get the message " This function takes no arguments".
Please help(:
Bookmarks