Substitute Final Score If Greater Than Low Score: IF, MIN & SUM Functions
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)
DESCRIPTION Topics in this video: (00:33) IF Function to deliver numbers. (01:37) IF Function to deliver text. (03:19) IF Function to deliver formulas. (05:19) IF Function to deliver functions. (07:51) Nested IFs. (10:24) Null Text [Read More >>>]
IF function Use the IF function to return one value if a condition is true and another value if it’s false. Syntax IF(logical_test, value_if_true, [value_if_false]) example: =IF(A2>B2,“Over Budget”,“OK”) =IF(A4=500,B4-A4,“”) WORKBOOKS
WORKBOOKS
Master Excel
Leave a Reply
You must be logged in to post a comment.