Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Scoring

Posted on 2014-02-05
21
Medium Priority
?
165 Views
Last Modified: 2014-02-05
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
0
Comment
Question by:Naresh Patel
  • 13
  • 8
21 Comments
 
LVL 31

Expert Comment

by:gowflow
ID: 39837189
Are you sure it is C29 for low not B29 ?
gowflow
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39837197
and all
C22 and C23 shouldn't they be B22 and B23 ?
gowflow
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39837204
.. 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
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837224
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
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837230
.. 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
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39837231
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
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837242
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
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837254
opps I mean to say what ever I mention in steps is right... sorry for confusion.

and all
C22 and C23 shouldn't they be B22 and B23 ?

Nope

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39837258
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
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837271
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 ??
Right Sir

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
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837286
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
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837298
Sir may I take your leave. it is too late here "3:38 AM".


Thanks
0
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 39837311
ok here is the file I fixed also your formulas not to have div0
check it out
gowflow
Scoring-G-V02.xlsm
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837337
Bang on target.

Now what you suggest. we stop here or want me to ask last part of this series?

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39837340
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
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837349
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
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39837353
no problem for testing. just post it
gowflow
0
 
LVL 8

Author Closing Comment

by:Naresh Patel
ID: 39837391
:)
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837394
here it is Scoring

Thanks
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837396
Leaving Now My Kid Are Waiting.

Thanks
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837469
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
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question