Hi all,
I had created a function based on the formula as attached but my function return value of 0 only. Please advise where I had gone wrong? Thanks.
MultimodalFnc.jpg
![]()
Please Login or Register to view this content.
Hi all,
I had created a function based on the formula as attached but my function return value of 0 only. Please advise where I had gone wrong? Thanks.
MultimodalFnc.jpg
![]()
Please Login or Register to view this content.
Can you give some examples of the numbers you are passing to the function?
If posting code please use code tags, see here.
Your function will take Pi to be a variable, equal to 0 as it is not defined. Therefore number*pi*0.05 will be equal to 0, sin(0) = 0, therefore x1 = x1*0 = 0 and MM = -2*0/x3 = 0. Try
Note, the power function doesn't work for me but that could be a version thing, I would use![]()
Please Login or Register to view this content.
instead![]()
Please Login or Register to view this content.
The function Power and the constant Pi do not exist in Excel
try
![]()
Please Login or Register to view this content.
If you like my contribution click the star icon!
Thanks...I need to define the Pi value. I had defined function of power.
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks