Go implementation of most Spreadsheet | Excel Formulas, 💡 by excelfunctions.net, formula.js

This library is currently under development.

• Math and Trigonometry functions
• Statistical functions
• Financial functions
• Date and time functions
• Logical Functions
• Engineering Functions
• Information Functions
• Text Functions
• Web Functions

use go get.

go get github.com/TaperBox/formulas

or to update

go get -u github.com/TaperBox/formulas

ERROR.TYPE is to test for specific errors and display a relevant message (instead of error values) when certain error conditions exist.

Error Code Key:

• 1 = #NULL!
• 2 = #DIV/0!
• 3 = #VALUE!
• 4 = #REF!
• 5 = #NAME?
• 6 = #NUM!
• 7 = #N/A
• 8 = #GETTING_DATA ...

Value and Common Error

import fm "github.com/TaperBox/formulas"

data := []float64{2, 1, 6, 4, 3, 5}

// Percentile 
p, err := fm.Percentile(60, nums...) // 60th Percentile

if err != nil {
	fmt.Println(err.Error())
	// Common Errors could be either

	// "#VALUE! - Occurred because the supplied value of k is non-numeric" 
	// or 
	// "#NUM!   - Occurred because the supplied value of k is less than 0 or greater than 100 or the array is empty

	return 
}

fmt.Println("Percentile: ", p) // Percentile: 4

Example

import fm "github.com/TaperBox/formulas"

Distributed under MIT License, please see license file in code for more details.