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 See two formulas: (04:00) MEDIAN Lower/Upper Date, Exclude Holidays: MEDAIN with IF, ISNA and MATCH (08:29) MEDIAN Lower/Upper Date, Exclude Holidays: AGGREGATE, ISNA and MATCH and Array Calculations (12:40) MEDIAN Lower/Upper Date, Exclude Holidays [Read More >>>]
DESCRIPTION See how to add every other column using 1 or 4 formulas: (00:08 min) Manual method using SUM. See how to highlight non-contiguous columns using a comma or the Ctrl key. This formula will [Read More >>>]
Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution? DESCRIPTION See how to deal with a Text Date in the form YYMMDD when some of the years are 1900 and some [Read More >>>]
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.
Leave a Reply
You must be logged in to post a comment.