A excle table has two columns of data need to implement related

According to the Guideline values, the Catalog automatically associated to the Require, Advisory, Mandatory one of three values

Such as when a Guideline value of 5.9, the Catalog value of Advisory
Guideline value of 12.1, the Catalog value of Advisory
Guideline value of 1.1, the Catalog values for the Require
Guideline value of 8.2, the Catalog values for the Require
Guideline value of 17.4, the Catalog value is Mandatory
Guideline value of 9.1, the Catalog value is Mandatory
Please great god answers, this should be how to implement

CodePudding user response:

 using the Select Case statement 
Please refer to the characteristics of 

When an expression when compared with several different values, you can use the Select a Case statement to alternate in the If... Then... ElseIf in the Else statement, If... Then... Else, will also have each ElseIf statements of different expression, at the top of the control structure, the Select Case statement expression only once, 

In the example below, the Select Case statement, will send to the performance parameters of the process, please note that each Case statement can contain more than one value, the scope of a value, or a combination of a value as well as the comparison operators, if Select Case statement match the Case statement of any value, the optional Case Else statements run, 

The Function Bonus (performance, salary) 
The Select Case performance 
Case 1 
Bonus salary * 0.1=
Case 2, and 3 
Bonus salary * 0.09=
Case 4 To 6 
Bonus salary * 0.07=
The Case Is & gt; 8 
Bonus=100 
In Case the Else 
Bonus=0 
End the Select 
End the Function 

CodePudding user response:

The "monkey" are only Posting, not stick?

CodePudding user response:

refer to the second floor Chen8013 response:

these "monkey" is only post, will not stick?

AI + ML monkey evolution is not enough,

CodePudding user response:

CodePudding user response:

refer to the second floor Chen8013 response:

these "monkey" is only post, will not stick?

CSDN is just redesign, cover page, BBS link has not directly visible, visible CSDN already think BBS is not important,

CodePudding user response:

reference 5 floor chewinggum reply:

Quote: refer to the second floor Chen8013 response:

The "monkey" are only Posting, not stick?

CSDN is just redesign, cover page, BBS link has not directly visible, visible CSDN has not been important think BBS,

All things have a life and death,
CSDN technology BBS is not exceptional also,

CodePudding user response:

Don't do the CSDN on ~ recently

CodePudding user response:

Obviously not AI, the AI can spell 'excle'?

CodePudding user response:

Is this excle ' ' ' 'to confused