This article will describe the below topics. Each topic will explain two formulas and in total, it will twenty formulas and even more. • IS FUNCTIONS-(ISERROR(value), ISFORMULA(value))
• CONDITIONAL-(SUMIF, IF)
• MATHEMATICAL-(SUBTOTAL,COUNT)
• FIND & SEARCH-(FIND,SEARCH)
• LOOKUP-(VLOOKUP,TRIM and VLOOKUP,HLOOKUP)
• REFERENCE-(Array Form,Reference Form)
• DATE & TIME-(YEAR, MONTH, DAY, HOUR, MINUTE and SECOND, DUE…