How to write this formula

Copper Contributor

I am trying to figure out how to write this as a single formula. Can anyone help?

 

  1. Use a logical formula to increase the grades of all students who received less than a 78 on Quiz 1 by 3 points and decrease the grades of all those who received more than a 95 by 2 points. The grades of all other students should remain the same.
2 Replies

@a104645Two possible solution are given in the attached workbook. One with the IFS function and another with nested IF functions. See which one works best for you. 

@a104645 

As variant

=A2+3*(A2<78)-2*(A2>95)