Need Formula To Get Score Result Based On Input

February 18, 2018 at 03:46:59
Specs: Windows 10
is there any one can help me to solved this problem?
if I enter number in score column will automatically give result as minus 2 in result column

Category Score Result

Number Observation raised during Y2018 Assessment  
- 2 Points from each High Risk level Observation
- 2 Points from each Medium Risk level Observation
- 2 Points from each Medium Risk level Observation
No. of open observations from Y2017 Assessment
- 3 Points for each 1 Open Observation


See More: Need Formula To Get Score Result Based On Input

Reply ↓  Report •

#1
February 18, 2018 at 05:58:15
First, a posting tip:

When posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "How To Solve This Problem" we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

Second, your requirements are not clear, at least not to me.

You said "if I enter number in score column will automatically give result as minus 2 in result column"

What that says to me is that you always want -2 in the result column, to which I was say, "Just enter -2". There doesn't seem to be any criteria as to why the result should be -2 (or any other number). Please keep in mind that we can't see your spreadsheet from where we are sitting nor to we know anything about your work process.

What are you trying to calculate? What inputs is the result based on?

Perhaps some example data, along with the expected output based on that data, would help. Before posting example data, please click on the following How-To link and read the instructions on how to post example data in this forum. Don't forget to include Column letters and Row numbers. Thanks!

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question