The IF Statement in Excel is a function that performs a logical test ... In the screenshot below, we want to return Pass or Fail for the Grade, depending on whether the value of the test scores ...
I will use VLOOKUP, because I want Excel to look up the values in the first column of table 1 to return each student's grade ...