Math 58

Numbers and formulas
Sorted from new to old.
Card image
MaxOfArray

Gets the maximum number from an array. Like

Card image
RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

Card image
IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

Card image
ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

Card image
CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

Card image
CountNumbers_inString

Returns how many numbers found inside a text

Card image
DecimalPlaces

Returns how many decimal places the number have

Card image
Min_No0s

Getting the minimum number from an array excluding zeros.

Card image
Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

Card image
Int function in ASP Classic (cint vs fix)

If you are looking for a function ASP Classic (VBScript) to do what Int() does ...

Card image
Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Card image
Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

Card image
Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

Card image
Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

Card image
ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

Card image
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...