IF – Excel for Engineers

Using SUMIF, COUNTIF and Similar “IF” Functions

ByRick November 3, 2022November 3, 2022

Do you need totals, an average, or a count of cells in a range, but only under certain circumstances? Then one of the several statistical “IF” functions will be useful. They let you use a criterion, or several criteria, to include or ignore chosen cells. They are:COUNTIF, COUNTIFS count those cells in a range that…

Excel Functions | Tips and Techniques

The Decisive IF Function in Excel

ByRick October 28, 2022November 7, 2022

Indecisive? Have difficulty making decisions? You need the IF function to do it for you! Seriously, though, the IF function can take a lot of the drudgery out of your formulas by applying simple yes/no rules. For example, say you’re calculating the velocity of flow in a water pipeline. In line with good practice, we…