Math 60

Numbers and formulas

Sorted from new to old.

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

Jan8

ANmaSum_4IFs

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

2024Nov13

MaxOfArray

Gets the maximum number from an array. Like

2024Oct24

RoundUp2

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

2024Oct1

IsNumericChar

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

2024Aug21

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

2024Aug11

CutString96_NumberX

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

2024Aug2

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

DecimalPlaces

Returns how many decimal places the number have

2024Jul24

Min_No0s

Getting the minimum number from an array excluding zeros.

2024Jun5

Between2int and Between2intinc

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

2024Mar23

Int function in ASP Classic (cint vs fix)

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

2024Feb6

Random Number in SQL

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

2024Jan30

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

1 2 3 4