Uncategorized

Example Related FunctionsEOMONTH NETWORKDAYS To calculate workdays per month, use the EOMONTH function together with the NETWORKDAYS function.In the ...

Example Related FunctionsDATE MONTH YEAR =MONTH(DATE(YEAR(date),2,29))=2If you want to test whether the year of a certain date is a leap year, you can ...

Example Related FunctionsVLOOKUP =VLOOKUP(val&"",table,col,0)A common problem with VLOOKUP is a mismatch between numbers and text. Either the first ...

Windows shortcut  Space Mac shortcut  Space This shortcut will toggle check and uncheck the checkbox for fields listed in the pivot table field ...

Example Related FunctionsVLOOKUP =VLOOKUP(val1&val2,data,col_index,0)One of the limitations of VLOOKUP is that it only handles one condition: the ...

Windows shortcut  ScrLk Mac shortcut  Fn⇧F14 This shortcut toggles Scroll Lock on and off. Note: the Scroll Lock status message may or may not be ...

Example Related FunctionsIFERROR VLOOKUP =IFERROR(VLOOKUP(value,table,2,FALSE),"")If you want to hide the #N/A error that VLOOKUP throws when it can't ...

Example Related FunctionsCOLUMNS ROWS =ROWS(rng)*COLUMNS(rng)If you need to count the total number of cells in a rectangular range, you can do so with ...

Example Related FunctionsCOLUMNS =COLUMNS(rng)If you need to count the number of columns in a range, use the COLUMNS function. In the generic form of ...

Example Related FunctionsMIN =IF(start<end,MIN(end,upper)-MAX(start,lower),MAX(0,upper-start)+MAX(0,end-lower))ContextYou have a start time and an ...

Example Related FunctionsROWS =ROWS(rng)If you need to count the number of rows in a range, use the ROWS function. In the generic form of the formula ...

Example Related FunctionsIF TRANSPOSE =TRANSPOSE(IF(rng="","",rng))To dynamically transpose a table that contains blanks, you can use an array formula ...

Excel - Excel Functions - Excel Formulas
Logo