Formulas

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

This library is currently under development.

Overview of functions

Installation

use go get.

go get github.com/TaperBox/formulas

or to update

go get -u github.com/TaperBox/formulas

Error

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 ...

Usage

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"

License