Math 59

Numbers and formulas

Sorted from new to old.

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

Wed 1PM

MaxOfArray

Gets the maximum number from an array. Like

Oct24

RoundUp2

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

Oct1

IsNumericChar

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

Aug21

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

Aug11

CutString96_NumberX

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

Aug2

CountNumbers_inString

Returns how many numbers found inside a text

Aug1

DecimalPlaces

Returns how many decimal places the number have

Jul24

Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5

Between2int and Between2intinc

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

Mar23

Int function in ASP Classic (cint vs fix)

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

Feb6

Random Number in SQL

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

Jan30

Column1Range

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

2023Oct7

Any2Dec

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

2023Sep20

Luhn

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

2023Jul25

ANmaInt

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

2023May2

1 2 3 4