IF (AND/OR(x=1;y=2);x...;y...)
NOT (<>0)
ISBLANK/ISNUMBER/ISTEXT/ISERROR/ISEVEN/ISODD/ISLOGICAL/ISFORMULA
RANK(A2;A1:B20)-rank A2fromA1:B20
PERCENTRANK
LARGE(A1:B20;8) 8th largest from a1-b20
SMALL(A1:B20;8) 8th smallest from a1-b20)
IS***
RAND
SUMPRODUCT
randbetween
INDEX
MATCH
Index
CHOOSE
OFFSET
row
column
today
now
left/right(cel,ileZnakow)
#NAME-text error ""
Ctrl+Home/End A1/bottomDown
Ctrl+. Corner
Ctrl+PgUp/Dwn-WorksheetsSwitch
exceljet.net/keyboard-shortcuts
Alt+H+V+V PasteValues
Alt+A+T Filters
IF(and(),OR()) NOT(A1=0) A1<>0
small,Large,Rank,PErcentrank
Rand() randomNumbers
Randbetween(0;100)
Sumproduct((A2:A22="Apple")*(B2:B22="Pear"))-->A2*B2+A3*B3...
countifs
sumifs
averageifs
row/rows
column/columns
index(array;row;column)
match("something";array;1/0/-1)largest/exact/smallest
CHOOSE(indexNum;value1;value2...)
OFFSET(reference;rows;columns;[height];[width])
COUNTA(A:A)
TRIM>SpaceRemoval
UPPER
LOWER
PROPER>>Proper
CONCATENATE/=CONCAT(A1;A2)// =A1&A2
=A1&"_"&A2
=LEFT/RIGHT(A1;5)
=MID(A1;4;5)-5characters starting from 4'th character
=LEN(A1)Length of a string
=TEXT(A1;"$#,###")
=SEARCH("xyz";A1) searches for xyz and returns position
=SEARCH("xyz";A1;10) searches for xyz starting from 10'th char and returns position
=MID(A1;SEARCH("xyz";A1);5)returns 5 chars from the middle of a string starting from xyz
=MID(A1;SEARCH("xyz";A1)+1;5)returns 5 chars from the middle of a string starting from 1 position after xyz
search case insensitive //find case sensitive
=IF(ISNUMBER(SEARCH("String";A1))"String";"Other") looking 4 specific txt
SUBSTITUTE(A1;"old";"new";whichOldIfMany)
DATEVALUE
TIMEVALUE
TODAY()
NOW()
YEAR/MONTH/DAY/HOUR/MINUTE/SECOND()
=EOMONTH(A1;0) End of a month
=EOMONTH(A1;-1)+1 Start of a month
=EOMONTH(A1;0)+1 Start of next month
YEARFRAC(cell with startdate;cell with enddate;1-4)
0defaultUS30/360
1actual (recommended)
2actual/360
3actual/365
4EU30/360
=WEEKDAY(cellWithDateAndTime;0-7)
0-7>start of the week
=WORKDAY(CellWithStartdate;daysBeforeOrAfter;OptionalHolidays)
=NETWORKDAY(CellWithStartdate;EndDate;OptionalHolidays)
=DATEDIF(StartDate;EndDate;"Unit")
Unit=D,M,Y,MD,YD,YM
=MOD(ROW();2)=1 EverySecondRow
NOT (<>0)
ISBLANK/ISNUMBER/ISTEXT/ISERROR/ISEVEN/ISODD/ISLOGICAL/ISFORMULA
RANK(A2;A1:B20)-rank A2fromA1:B20
PERCENTRANK
LARGE(A1:B20;8) 8th largest from a1-b20
SMALL(A1:B20;8) 8th smallest from a1-b20)
IS***
RAND
SUMPRODUCT
randbetween
INDEX
MATCH
Index
CHOOSE
OFFSET
row
column
today
now
left/right(cel,ileZnakow)
#NAME-text error ""
Ctrl+Home/End A1/bottomDown
Ctrl+. Corner
Ctrl+PgUp/Dwn-WorksheetsSwitch
exceljet.net/keyboard-shortcuts
Alt+H+V+V PasteValues
Alt+A+T Filters
IF(and(),OR()) NOT(A1=0) A1<>0
small,Large,Rank,PErcentrank
Rand() randomNumbers
Randbetween(0;100)
Sumproduct((A2:A22="Apple")*(B2:B22="Pear"))-->A2*B2+A3*B3...
countifs
sumifs
averageifs
row/rows
column/columns
index(array;row;column)
match("something";array;1/0/-1)largest/exact/smallest
CHOOSE(indexNum;value1;value2...)
OFFSET(reference;rows;columns;[height];[width])
COUNTA(A:A)
TRIM>SpaceRemoval
UPPER
LOWER
PROPER>>Proper
CONCATENATE/=CONCAT(A1;A2)// =A1&A2
=A1&"_"&A2
=LEFT/RIGHT(A1;5)
=MID(A1;4;5)-5characters starting from 4'th character
=LEN(A1)Length of a string
=TEXT(A1;"$#,###")
=SEARCH("xyz";A1) searches for xyz and returns position
=SEARCH("xyz";A1;10) searches for xyz starting from 10'th char and returns position
=MID(A1;SEARCH("xyz";A1);5)returns 5 chars from the middle of a string starting from xyz
=MID(A1;SEARCH("xyz";A1)+1;5)returns 5 chars from the middle of a string starting from 1 position after xyz
search case insensitive //find case sensitive
=IF(ISNUMBER(SEARCH("String";A1))"String";"Other") looking 4 specific txt
SUBSTITUTE(A1;"old";"new";whichOldIfMany)
DATEVALUE
TIMEVALUE
TODAY()
NOW()
YEAR/MONTH/DAY/HOUR/MINUTE/SECOND()
=EOMONTH(A1;0) End of a month
=EOMONTH(A1;-1)+1 Start of a month
=EOMONTH(A1;0)+1 Start of next month
YEARFRAC(cell with startdate;cell with enddate;1-4)
0defaultUS30/360
1actual (recommended)
2actual/360
3actual/365
4EU30/360
=WEEKDAY(cellWithDateAndTime;0-7)
0-7>start of the week
=WORKDAY(CellWithStartdate;daysBeforeOrAfter;OptionalHolidays)
=NETWORKDAY(CellWithStartdate;EndDate;OptionalHolidays)
=DATEDIF(StartDate;EndDate;"Unit")
Unit=D,M,Y,MD,YD,YM
=MOD(ROW();2)=1 EverySecondRow