So you can essentially ignore SUMIF as SUMIFS is a superior function. It sums values that meet specified criteria.Įxcel also has a function named SUMIF which does the same task except it can only test one condition, while SUMIFS can test many. SUMIFS is one of the most useful Excel functions. In this example, we have displayed the word “Yes” if the delivery date in column C is more than 7 days later than the order date in column B.
=IF(logical test, value if true, value if false) The IF function asks you for the logical test to perform, what action to take if the test is true, and the alternative action if the result of the test is false. With IF, we could get Excel to perform a different calculation or display a different value dependent on the outcome of a logical test (a decision).
This function means we can automate decision making in our spreadsheets.
0 kommentar(er)
