Hi...
I have this PERCENTILE formula which I need to implement in VBA
=PERCENTILE(IF('RAW C TIME'!$D$2:$D$51816=$J7,IF('RAW C TIME'!$J$2:$J$51816=$K$4,IF($K$3="(All)",'RAW C TIME'!$I$2:$I$51816,IF('RAW C TIME'!$G$2:$G$51816=$K$3,'RAW C TIME'!$I$2:$I$51816)))),N$6)
The idea is to pass all the ranges and values as parameters for a custom Function.
I already accomplished this and it is working as expected. The only problem I have is that in some cases there are too many parameters, and since I am using Evaluate to run the function and then return the result, if the function gets too long (more than 255 characters) then Evaluate fails...
So... I am wondering if there is a way to resolve first all the "IF's" so I can just pass the range or array needed for the percentile... Is there a way in VBA to resolve the nested if as it is in the function?
can anyone tell me where I can find documentation that will guide me to accomplish this?
Thanks
Bookmarks