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)
Leave a Reply
You must be logged in to post a comment.