Session 1: Tutorial 1

Excel updates the formula bar to read =IF(A1>0,“In Stock”,“Backordered”). For the CountIf function, the following window appears: In the range field, enter where you want Excel to look for a specific value (for example, B2:B9). In the criteria field, enter the specific value that you want Excel to find (for example, “Backordered”). ................
................