Spreadsheets for Finance and Accounting

  1. Essential Financial Functions
    1. Logical Functions
      1. IF Function
        1. Nested IF Statements
          1. AND Function
            1. OR Function
              1. NOT Function
                1. IFERROR Function
                  1. IFS Function
                  2. Lookup and Reference Functions
                    1. VLOOKUP Function
                      1. HLOOKUP Function
                        1. INDEX Function
                          1. MATCH Function
                            1. INDEX-MATCH Combinations
                              1. XLOOKUP Function
                                1. CHOOSE Function
                                2. Mathematical Functions
                                  1. SUMIF Function
                                    1. SUMIFS Function
                                      1. COUNTIF Function
                                        1. COUNTIFS Function
                                          1. AVERAGEIF Function
                                            1. AVERAGEIFS Function
                                              1. ROUND Functions
                                                1. ABS Function
                                                  1. MOD Function
                                                  2. Date and Time Functions
                                                    1. TODAY Function
                                                      1. NOW Function
                                                        1. DATE Function
                                                          1. YEAR Function
                                                            1. MONTH Function
                                                              1. DAY Function
                                                                1. EOMONTH Function
                                                                  1. EDATE Function
                                                                    1. DATEDIF Function
                                                                      1. YEARFRAC Function
                                                                        1. NETWORKDAYS Function
                                                                        2. Text Manipulation Functions
                                                                          1. CONCATENATE Function
                                                                            1. CONCAT Function
                                                                              1. LEFT Function
                                                                                1. RIGHT Function
                                                                                  1. MID Function
                                                                                    1. LEN Function
                                                                                      1. FIND Function
                                                                                        1. SEARCH Function
                                                                                          1. SUBSTITUTE Function
                                                                                            1. REPLACE Function
                                                                                              1. TEXT Function
                                                                                                1. VALUE Function
                                                                                                  1. TRIM Function

                                                                                                Previous

                                                                                                3. Formula Fundamentals

                                                                                                Go to top

                                                                                                Next

                                                                                                5. Data Organization and Management