Help on giving Optional Functions a value when they are a range and they are missing.
------------------------------------
ExponentialCDF(Weight As Range, Theta As Range, Optional Maximum As Range)
If IsMissing(maximum) then
------------------------------
Now if a maximum is not entered I want the maximum to be 999999999999 in all cases.
The number of cases would be identical to the number of (pieces?) in the Theta and Weight Ranges.
For example
ExponentailCDF(A1:b1,d1:d2)
This should produce
weight(1) = value in cell a1
weight(2) = value in cell b1
Theta(1) = value in cell d1
Theta(2) = value in cell d2
This part works fine and dandy (and if I enter in a range for the maximums it works fine as well). It's when I don't want to specify a maximum that it doesn't work in this case I'd want
Maximum(1) = 999999999999
Maximum(2) = 999999999999
I'll post some more of the actual code in the next post.
------------------------------------
ExponentialCDF(Weight As Range, Theta As Range, Optional Maximum As Range)
If IsMissing(maximum) then
------------------------------
Now if a maximum is not entered I want the maximum to be 999999999999 in all cases.
The number of cases would be identical to the number of (pieces?) in the Theta and Weight Ranges.
For example
ExponentailCDF(A1:b1,d1:d2)
This should produce
weight(1) = value in cell a1
weight(2) = value in cell b1
Theta(1) = value in cell d1
Theta(2) = value in cell d2
This part works fine and dandy (and if I enter in a range for the maximums it works fine as well). It's when I don't want to specify a maximum that it doesn't work in this case I'd want
Maximum(1) = 999999999999
Maximum(2) = 999999999999
I'll post some more of the actual code in the next post.