Ravindra BagaleCourses & study guides मराठी Track your progress

Ravi Sir's Cards › Excel

Pass/Fail, blanks and FORMULATEXT

Revision card: Pass/Fail, blanks and FORMULATEXT. Example data table with Pass or Fail for ID 1: Pass; Blank or 0 for an absent student?: 1 absent; Show the formula behind F2: =IF(C2>=35,"Pass","Fail").

Revision card: Pass/Fail, blanks and FORMULATEXT. Example data table with Pass or Fail for ID 1: Pass; Blank or 0 for an absent student?: 1 absent; Show the formula behind F2: =IF(C2>=35,"Pass","Fail").
Card 2 of 2: Pass/Fail, blanks and FORMULATEXT · Download PNG
Read card text

What this card says

Pass/Fail, blanks and FORMULATEXT

Example

data table with Pass or Fail for ID 1: Pass; Blank or 0 for an absent student?: 1 absent; Show the formula behind F2: =IF(C2>=35,"Pass","Fail")

Learn this in the lesson: Excel COUNT, COUNTA, COUNTBLANK and COUNTIF: Total Students, Absentees and Pass Percentage (with MAX and MIN)

See all Excel revision cards