Math 57

Numbers and formulas
Sorted from new to old.
Card image
MinIF and MaxIF in Excel 2010

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

Card image
IsBin

Checks if the passed argument is a binary or not

Card image
IsEven + IsOdd

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

Card image
Hex2Int

Converts hex to Integer

Card image
Bin2Int

Converts Binary to Integer

Card image
InternationalComma

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

Card image
DegreeC2K

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

Card image
IsPrime

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

Card image
CalcArea

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

Card image
MetricToUSStandard

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

Card image
USStandardToMetric

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

Card image
Weighted_Average

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

Card image
PI

Returns a double representing the mathematical constant Pi

Card image
DegreeC2F + DegreeF2C

Convert Celsius to Fahrenheit and Fahrenheit to Celsius degrees

Card image
RandomArray

Creates array of random numbers, returns 1 Dim array

Card image
RandomNumber

Generate random number between Lower and upper numbers provided