mercredi 24 janvier 2018

Replace/Update Value in Column Using If statement

Consider this example. There are two columns one called grade with a number 1-10 and another called status that says pass or fail. Originally, any number 1-6 resulted in fail and everything from 7-10 said pass.

Grade | Status
  1   |  Fail
  2   |  Fail
  3   |  Fail
  4   |  Fail
  5   |  Fail
  6   |  Fail
  7   |  Pass
  8   |  Pass
  9   |  Pass
 10   |  Pass

Now I lowered the passing grade to a 6. I want to replace every fail in the status column with pass if it has a grade of 6. How would I do this using an if statement in Excel?

Aucun commentaire:

Enregistrer un commentaire