Skip to main content
J
justhumm10-Marble
10-Marble
January 2, 2024
Solved

Custom Function Error - This value must be an integer

  • January 2, 2024
  • 1 reply
  • 988 views
This is sort of a follow-up question to this thread where I was recreating the calculations of the ptc sample:
 
Once I got that working, I defined two functions that process the spread-sheet wide variables, which was working "properly" for me:
     a = [matrix]     w = [matrix]     p = [matrix]     ML = number     MR = number
When I tried to move all arguments into the function definitions and I am getting error: "This value must be an integer."
     M(x,a,w,p,ML,MR) and V(x,a,w,p,ML,MR)
 
I'm having trouble figuring out what is causing this. Can anyone point out what I am missing?
Thanks!
error.png
Best answer by Werner_E
@justhumm wrote:
This is sort of a follow-up question to this thread where I was recreating the calculations of the ptc sample:
 

You may consider closing the threads you opened if you decide to open a new thread for follow ups.
I guess the question in the first link you mention may be considered answered.
I also don't feel that your new question is a follow up as it has nothing to do  with the problems you experienced in the other threads.

 

Your new problem occurs because you used a range in your program. In programs you have to use for-loops instead!

Werner_E_0-1704248208337.png

 

 

1 reply

W
Werner_E25-Diamond IAnswer
25-Diamond I
January 3, 2024
@justhumm wrote:
This is sort of a follow-up question to this thread where I was recreating the calculations of the ptc sample:
 

You may consider closing the threads you opened if you decide to open a new thread for follow ups.
I guess the question in the first link you mention may be considered answered.
I also don't feel that your new question is a follow up as it has nothing to do  with the problems you experienced in the other threads.

 

Your new problem occurs because you used a range in your program. In programs you have to use for-loops instead!

Werner_E_0-1704248208337.png

 

 

    Terms & ConditionsCookie settingsAccessibility statement