![]() For instance, here to calculate the difference between column Value 1 and column Value 2 in column Differences, and you want to keep the cell blank if there are some blank cells in the column Value 1 and column Value2. Type the array formula into the first cell (or if already typed into the first cell, put this cell into edit mode by pressing F2 or clicking in the formula bar) Press Ctrl + Shift + Enter (i. ![]() Since a Date is a serial number, from Excel. The line «will come to working condition» by itself. The list in cell F2 is created just like in the previous example. Press the F2 key to enter into the formula: Back to top.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |