In this entryway, stone tiles run right down the middle of the hall with wood on either side, almost like a carpet. I love the tone-on-tone look of the dark espresso color for both materials. Inspiration for a contemporary front door in Toronto with a single front door and a dark wood front door.
Example 1 - Omitting the Reference Argument with the ROW Function. 1  Click on cell B2 to make it the active cell; 2  Type the formula =ROW() into the cell. 3  Press the Enter key on the keyboard to complete the function;  The number  2  should appear in cell B2 since the function is located in second row of the worksheet;
The Microsoft Excel MIN function returns the smallest number in a list of arguments. If the smallest number is zero (0), the function returns zero. To return the smallest number greater than zero, enter the following array formula. where A1:A10 represents the range of the numbers. This returns an array of a single value with the smallest positive number. NOTE: To enter an array formula in Excel for the Macintosh, press COMMAND+RETURN.