EXCEL BASIC EXCEL BASIC SUM SUM ASSIGNMENT SUM ASSIGNMENT 02 SUBSTRATION ASSIGNMENT MULTIPLICATION ASSIGNMENT DIVIDE ASSIGNMENT SUM NOTES AVERAGE ASSIGNMENT Average Assignment Average Assignment Notes COUNT Count Assignment Count Notes And Assignment COUNTA Upcomming Upcomming MAX Upcomming Upcomming MIN Upcomming Upcomming PRODUCT Upcomming Upcomming MEDIAN Upcomming Upcomming MODE Upcomming Upcomming STDEV Upcomming Upcomming STDEV.S Upcomming Upcomming STDEV.P STDEV.P STDEV.P VAR VAR VAR VAR.S VAR.S VAR.S VAR.P VAR.P VAR.P IF IF IF IFERROR IFERROR IFERROR IFNA IFNA IFNA AND AND AND OR OR OR NOT NOT NOT XOR XOR XOR SWITCH SWITCH SWITCH Notes CHOOSE CHOOSE CHOOSE VLOOKUP VLOOKUP VLOOKUP HLOOKUP HLOOKUP HLOOKUP LOOKUP LOOKUP LOOKUP INDEX INDEX INDEX MATCH MATCH MATCH INDIRECT INDIRECT INDIRECT OFFSET OFFSET OFFSET TRANSPOSE TRANSPOSE TRANSPOSE UNIQUE UNIQUE UNIQUE RAND RAND RAND RANDBETWEEN RANDBETWEEN RANDBETWEEN PMT PMT PMT PV PV PV FV FV FV RATE RATE RATE NPV NPV NPV IRR IRR IRR XIRR XIRR XIRR XNPV XNPV XNPV ROUND ROUND ROUND ROUNDUP ROUNDUP ROUNDUP ROUNDDOWN ROUNDDOWN ROUNDDOWN MROUND MROUND MROUND CEILING CEILING CEILING FLOOR FLOOR FLOOR TRUNC TRUNC TRUNC FIXED FIXED FIXED TEXT TEXT TEXT VALUE VALUE VALUE CONCAT CONCAT CONCAT CONCATENATE CONCATENATE CONCATENATE LEFT LEFT LEFT RIGHT RIGHT RIGHT MID MID MID LEN LEN LEN SEARCH SEARCH SEARCH FIND FIND FIND SUBSTITUTE SUBSTITUTE SUBSTITUTE REPLACE REPLACE REPLACE REPT REPT REPT CODE CODE CODE CHAR CHAR CHAR UPPER UPPER UPPER LOWER LOWER LOWER PROPER PROPER PROPER DATE DATE DATE TIME TIME TIME DAY DAY DAY MONTH MONTH MONTH YEAR YEAR YEAR HOUR HOUR HOUR MINUTE MINUTE MINUTE SECOND SECOND SECOND NETWORKDAYS NETWORKDAYS NETWORKDAYS WORKDAY WORKDAY WORKDAY EOMONTH EOMONTH EOMONTH EDATE EDATE EDATE TODAY TODAY TODAY YEARFRAC YEARFRAC YEARFRAC