DpMay 1, 20181 min"INT" Function In ExcelThis function rounds the number to its nearest Whole Number. Syntax: =INT(num) Example: The Table has some Numbers, and In the right...
DpMay 1, 20181 min"IF" Function In ExcelThis function tests a condition / Logic If the condition is met it is considered to be TRUE.If the condition is not met it is considered...
DpMay 1, 20181 min"HLOOKUP" Function In ExcelThis function scans across the column headings at the top of a table to find a specified item.When the item is found, it then scans down...
DpMay 1, 20181 min"FREQUENCY" Function In ExcelThis function compares a range of data against a list of intervals.The result shows how many items in the range of data fall between the...