Excel Magic Trick 1165

Substitute Final Score If Greater Than Low Score: IF, MIN & SUM Functions

DESCRIPTION

See how to Add 4 Tests Scores, But Substitute Final Score If Greater Than Low Test Score using the IF, MIN and SUM Functions.

MUCH easier formula:

=SUM(A6:E6)-MIN(A6:E6)




Be the first to comment

Leave a Reply