Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 22:41:05 +0000



Post From: function

[2014-10-07 15:25:58]
julian pineda - Posts: 60
look up the pic,

just columns Q and R:

http://screencast.com/t/M8CWpoi6


this is what i need:
Step 1: when Q column touch 40%
step 2: how much was R column when Q touch 40%, so in P column returns me the value of R when Q was > 40%.

if i do this: =if(Q>0,40;R;"no") in P i will get a moving number, because the market flows. and i need just the number R was when Q > 40%. just that number, the frozen number, the exact number...

Do i Explain my self better?