ACCEPTED SOLUTION
Accepted Solutions
@fahmed-2 wrote:
I think I found a solution.
Vectorization as suggested above does the job as well and a bit more elegant, I guess.
Your program with "Match" and "trim" would throw an error if the function a(..) once returns a vector without a single value being 0 or less. You may use "try..catch" to cope with this or look at my suggestion below.
Worksheet attached.
The problem is the equal sign after the definition of your function "a".
Delete it and it should work.
But now you get a unit mismatch because something with your function f is wrong.
You try to add unit-less (the first sine summand) and a summand which hast the unit Pa/m. This can't work.
@fahmed-2 wrote:
Thank you for your reply. Yes, you are right the units of alpha should be per meter but still it does not work. I want my variable "a" to be defined such that it is a function of alpha, d, and x.
Which indeed it is.
You did not attach your new file so we do not see where your new sheet fails and what the error message is.
Best guess is that you forgot to vectorize:
@fahmed-2 wrote:
I think I found a solution.
Vectorization as suggested above does the job as well and a bit more elegant, I guess.
Your program with "Match" and "trim" would throw an error if the function a(..) once returns a vector without a single value being 0 or less. You may use "try..catch" to cope with this or look at my suggestion below.
Worksheet attached.
