johnny_trauma
New Member
- Joined
- Sep 12, 2006
- Messages
- 14
I can't seem to stay off this board today.
I thought I had figured out this problem, but to my dismay I was grossly mistaken.
I have a formula used to calculate the percentile when two conditions are met, and I am now trying to edit it to contain a third condition. The catch is that either the second or third condition must be true, not both.
My current formula looks like this:
=percentile(if(rangeA=x,if(rangeB=y,rangeD)),0.25)
but I need to add ...if(rangeB=y or rangeC=z,rangeD)...
Any suggestions?
I thought I had figured out this problem, but to my dismay I was grossly mistaken.
I have a formula used to calculate the percentile when two conditions are met, and I am now trying to edit it to contain a third condition. The catch is that either the second or third condition must be true, not both.
My current formula looks like this:
=percentile(if(rangeA=x,if(rangeB=y,rangeD)),0.25)
but I need to add ...if(rangeB=y or rangeC=z,rangeD)...
Any suggestions?