This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets. 50 Excel Shortcut to Increase Your Productivity. We get the result below.
First the DATE function creates the date 5.
To apply the custom time format click Ctrl 1 to open the Format Cells dialog select Custom from the Category list and type the time codes in the Type box. The Excel IF function will work if the logical_test returns a numeric value. To see how altering one of the formula values alters the result change the data in cell C1 from 3 to 6 and press Enter on your keyboard. Weve put together 10 Excel formulas you need to get started.