Naresh Patel
asked on
Scoring
Hi Expert,
I need to do this process via VBA.
On Button click analyze
if C29=”Low” then
+1 @ Cell B58 & D58 & F58 & H58
Find C22 Value from Range C12:C20 (+ or – 4 point leverage)
if True then find respective factor in range B49:B57 & Add +1 else nothing next step
Find C23 Value in Range C12:C20(+ or – 4 point leverage)
if true then find respective factor in range D49:D57 & Add +1else nothing next step
Find C22 value from range G12:G20(+ or – 4 point leverage)
if true then find respective factor in range F49:F57 & Add +1 else nothing next step
Find C23 value from range G12:G20(+ or – 3 point leverage)
if true then find respective factor in range H49:H57 & Add +1 else nothing. End
See attached File.
Thanks
Scoring-G-V01.xlsm
I need to do this process via VBA.
On Button click analyze
if C29=”Low” then
+1 @ Cell B58 & D58 & F58 & H58
Find C22 Value from Range C12:C20 (+ or – 4 point leverage)
if True then find respective factor in range B49:B57 & Add +1 else nothing next step
Find C23 Value in Range C12:C20(+ or – 4 point leverage)
if true then find respective factor in range D49:D57 & Add +1else nothing next step
Find C22 value from range G12:G20(+ or – 4 point leverage)
if true then find respective factor in range F49:F57 & Add +1 else nothing next step
Find C23 value from range G12:G20(+ or – 3 point leverage)
if true then find respective factor in range H49:H57 & Add +1 else nothing. End
See attached File.
Thanks
Scoring-G-V01.xlsm
and all
C22 and C23 shouldn't they be B22 and B23 ?
gowflow
C22 and C23 shouldn't they be B22 and B23 ?
gowflow
.. and shouldn't the factor when they are negative be for low and when positive be for High ??
like range for low be C2:C10 and high C12:C20 ???
gowflow
like range for low be C2:C10 and high C12:C20 ???
gowflow
ASKER
Are you sure it is C29 for low not B29 ?
Yes I am sure.
and all
C22 and C23 shouldn't they be B22 and B23 ?
Yes
thanks
ASKER
.. and shouldn't the factor when they are negative be for low and when positive be for High ??
like range for low be C2:C10 and high C12:C20 ???
Not that way. if we are calculating from low point need to add values ( positive Factors) & vice versa.
Thanks
you said yes for this
and all
C22 and C23 shouldn't they be B22 and B23 ?
means your post is wrong ? or it should be like your post no error ???
gowflow
and all
C22 and C23 shouldn't they be B22 and B23 ?
means your post is wrong ? or it should be like your post no error ???
gowflow
ASKER
So what ever I mention in steps is right. I had read it this "Current Price With Current Time Range" five times from my book & it is like that only.
Thanks
Thanks
ASKER
opps I mean to say what ever I mention in steps is right... sorry for confusion.
Nope
Thanks
and all
C22 and C23 shouldn't they be B22 and B23 ?
Nope
Thanks
so if Cell C29 is High it cannot be Low so it will do either or right ??
like if it is High it should do all the steps in the previous question and if it is low then it will do all the steps in this question.
It will never do both at the same time. Right ??
then if it is like this why you have B29 = low and above it there are low figures and C29 = high and there are high figures ? if we are only looking for C29 only ??
gowflow
like if it is High it should do all the steps in the previous question and if it is low then it will do all the steps in this question.
It will never do both at the same time. Right ??
then if it is like this why you have B29 = low and above it there are low figures and C29 = high and there are high figures ? if we are only looking for C29 only ??
gowflow
ASKER
so if Cell C29 is High it cannot be Low so it will do either or right ??Right Sir
like if it is High it should do all the steps in the previous question and if it is low then it will do all the steps in this question.
It will never do both at the same time. Right ??
then if it is like this why you have B29 = low and above it there are low figures and C29 = high and there are high figures ? if we are only looking for C29 only ??Yes we are looking C29 only
Thanks
ASKER
I guess you wondered this range also A32:L32 why I had taken this in sheet even not using any of it except "Low".. but in next different kind of scoring this may required.
Thanks
Thanks
ASKER
Sir may I take your leave. it is too late here "3:38 AM".
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Bang on target.
Now what you suggest. we stop here or want me to ask last part of this series?
Thanks
Now what you suggest. we stop here or want me to ask last part of this series?
Thanks
ask the question ... and go sleep I will work on it tomorrow but at least its here.
if you have time if not leave for tomorrow
gowflow
if you have time if not leave for tomorrow
gowflow
ASKER
yes I have but I cant available for testing. as I will on my way back to home. I can reply only.
Waite for 1 min
Thanks
Waite for 1 min
Thanks
no problem for testing. just post it
gowflow
gowflow
ASKER
:)
ASKER
ASKER
Leaving Now My Kid Are Waiting.
Thanks
Thanks
ASKER
Sir one request pls add comment in new question" I will look in to this later". If you feel to solve that question. As no one else jump in to that question otherwise I have to post big description to make him understand.
Thank Yoi
Thank Yoi
gowflow