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)
Quickly SUM an entire row or column by clicking in the first empty cell in the column or row. Use the shortcut keys ALT + = Excel will guess the range you want to sum. […]
DESCRIPTION Learn how to to create three different formulas to calculate minimum value greater than zero: (00:13) Introduction (01:00) Before Excel 2010: =MIN(IF(C4:T4 greater0,C4:T4)) (03:05) Excel 2010 – 2013: =AGGREGATE(15,6,C4:T4/(C4:T4 greater0),1) (04:53) Excel 2016 or […]
IF Function: Checking For Empty Cells (5 Methods) DESCRIPTION IF Function: Checking For Empty Cell & Zero Length Text Strings: (00:08) Problem Setup (00:56) IF function logical test using Zero Length Text String (checks for […]
Master Excel
Leave a Reply
You must be logged in to post a comment.