Use expected value
Joshua Kaufman
Can you use expected value in another calculation by referencing the cell?
For example, am checking if CELL > x ? 1 : 0. This results in either a 1 or a 0 for results, but the expected value comes out as .04 in my case. I want to do arithmetic on this value, but i can since the real values (0 or 1) pass through, and so exponents wont work.