A Database Error Occurred

Error Number: 1048

Column 'tags' cannot be null

INSERT INTO `questions` (`title`, `question`, `course`, `upvote`, `userid`, `answers`, `tags`, `created`, `modified`) VALUES ('Advance Excel', '

Hello Friends,

I have a certain below criteria on given data:

\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Score<64F
<73D
<85C
<95B
OtherwiseA

I need to calculate grade using VLOOKUP function only.  Can you please help me out?

Thanks,

Debapriya Bej


  Debapriya Bej

Please specify the question more, it is not clear to me.

  Devbrat Tripathi       10 Dec 2017       0       0     

Hi,

It seems that you want to find the Grades based on below data. if the value is 5 then it should give the Grade E, if the value is greater than 64 or 64 then the grade should be F. I hope below answer will help you.

RangeGrade
1E
64F
73D
85C
95B
100A

You can use below Formula to solve this problem and result will be just like below-


=VLOOKUP(B2,B5:C10,2,TRUE)


LookupValue Formula
4

E



  Devbrat Tripathi       17 Dec 2017       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any