Wall Street Prep: Excel Crash Course Formulas

Wall Street Prep: Excel Crash Course Formulas =AVERAGE(number1,[number2],...) - ANSWER-Average Function =IF(logical test, [value if true], [value if false]) - ANSWER-Simple IF Function =IFS(logical test n, value if true n, value if false n) - ANSWER-IFS Function =IFERROR(value, value_if_error) - ANSWER-IFERROR Function =EOMONTH(start_date,months) - ANSWER-EOMONTH Function =EDATE(start date,months) - ANSWER-EDATE Function =ISNUMBER(value) - ANSWER-ISNUMBER Function =ISTEXT(value) - ANSWER-ISTEXT Function =YEARFRAC(start_date,End_date,Basis) - ANSWER-YEARFRAC Function =DATE(year, month, day) - ANSWER-DATE Function =DAY(Serial Number) - ANSWER-DAY Function =MONTH(serial number) - ANSWER-MONTH Function =YEAR(Serial Number) - ANSWER-YEAR Function =AND(logical1,[logical2],...) - ANSWER-AND Function =OR(logical1,[logical2],...) - ANSWER-OR Function =HLOOKUP(Lookup Value, Table Array, Row Index Number, [Range Lookup]) - ANSWER-HLOOKUP (Horizontal Lookup) Function =VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]) - ANSWER-VLOOKUP (Vertical Lookup) Function =XLOOKUP(lookup_value,lookup_array,return_array,[if not found]) - ANSWER-XLOOKUP (Excel Lookup) Function =XMATCH(lookup_value,lookup_array,[match_mode],[search_mode]) - ANSWER-XMATCH Function =INDIRECT(referencetext) - ANSWER-INDIRECT Function =INDEX(array,row_num,[column_num]) - ANSWER-INDEX Function =CHOOSE(index_num,value1,value2,value n) - ANSWER-CHOOSE Function =OFFSET(reference,rows,columns,[height,[width]) - ANSWER-OFFSET Function =ADDRESS(row_num,col_num,[abs_num],[a1],[sheet text]) - ANSWER-ADDRESS Function =COLUMN(reference) - ANSWER-COLUMN Funtion =ROW(reference) - ANSWER-ROW Function =SUMPRODUCT(array1,[array2],[array3],...) - ANSWER-SUMPRODUCT Function =SUMIF(range, criteria, [sum_range]) - ANSWER-SUMIF Function =AVERAGEIF(range,criteria,[average_range]) - ANSWER-AVERAGEIF Function =SUMIFS(range1,criteria_range1,criteria1,etc.) - ANSWER-SUMIFS Function =AVERAGEIFS(average_range,criteria_range1,criteria1,[criteria_range2,criteria2],...) - ANSWER-AVERAGEIFS Function =ABS(number) - ANSWER-absolute value function =CEILING(number,significance) - ANSWER-CEILING Function =FLOOR(number,signifiance) - ANSWER-FLOOR Function =COMBIN(number,number_chosen) - ANSWER-Combination Function =ROUND(number,num_digits) - ANSWER-ROUND Function =ROUNDUP(number,num_digits) - ANSWER-ROUNDUP Function =ROUNDDOWN(number,num_digits) - ANSWER-ROUNDDOWN