Math 59

Numbers and formulas

Sorted from new to old.

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

2019May5

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

IsBin

Checks if the passed argument is a binary or not

2018Oct16

IsEven + IsOdd

Returns True if integer is even by using IsEven While IsOdd, will returns True ...

2018Sep27

Hex2Int

Converts hex to Integer

2018Sep27

Bin2Int

Converts Binary to Integer

2018Sep27

InternationalComma

Convert an international numeric with , instead of . Into American style . ...

2018Aug8

DegreeC2K

Convert a Celsius temperature to a Kelvin temperature. To convert Fahrenheit ...

2018Jul25

IsPrime

Checks to see if a number is a primary number. Prime numbers are commonly found ...

2018Jul25

CalcArea

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

MetricToUSStandard

Converts a Metric Measure into a US Standard Measure. Arguments: ...

2018Jul17

USStandardToMetric

Converts US Standard Measure into a Metric Measure. Arguments: ...

2018Jul15

Weighted_Average

Does a weighted average, knowing that mathematical average between two numbers ...

2018Jul7

PI

Returns a double representing the mathematical constant Pi

2018Jul5

DegreeC2F + DegreeF2C

Convert Celsius to Fahrenheit and Fahrenheit to Celsius degrees

2018Jul3

1 2 3 4