How to detect threshold within a cell range [closed]
Hi!
I'd like to detect where a value reaches a threshold within a range of cells. When the threshold is reached, I want to read a cell above. My table contains a %age that grows up to 100%. I'd like to find when it reaches 70% and read the cell just above the >70% value.
Couldn't find any smart function to do this...
Thanks! Laurent