WEMBA Excel Review - Duke University

One way to write Excel’s nested IF function is: =IF(condition-to-test, IF(condition-to-test, value-if-condition-true, value-if-condition-false), value-if-condition-true, value-if-condition-false) Excel’s SUMPRODUCT function multiplies corresponding components in the … ................
................