When used indendently, they return TRUE or FALSE ... D2="Gold") because I want Excel to tell me whether the value in B2 is greater than 18 and the value in D2 is equal to "Gold".
The IF statement is a popular logical function in Excel ... to return Pass or Fail for the Grade, depending on whether the value of the test scores in column C is greater than or equal to 50.
Some results have been hidden because they may be inaccessible to you