https://joeliufoundation.org/_assets/5b2cc483b154738a.strings.js

1(function(){
2const messages=JSON.parse("{\"yTCqEQ\":\"Absolute value. Removes minus signs from negative numbers.\",\"qpF0/Q\":\"Adds selected numbers.\",\"E5NZfg\":\"Adds the differences of squares of paired values from two ranges.\",\"SLojAw\":\"Adds the products of two equally sized ranges.\",\"uTcyLA\":\"Adds the squares of the differences of paired values from two ranges.\",\"CMjNzQ\":\"Adds the squares of the selected numbers.\",\"sBcfXg\":\"Adds the sums of squares of paired values from two ranges.\",\"toEMSQ\":\"Adds the values in a range that meet a specified condition.\",\"FpeQjw\":\"Adds the values in a range that meet multiple specified conditions.\",\"0OZlXw\":\"Calculates the average of cells that meet a specified condition.\",\"UNcBHQ\":\"Calculates the average of cells that meet multiple specified conditions.\",\"JxfUTg\":\"Calculates the base-10 logarithm of a number.\",\"o+jEsg\":\"Calculates the correlation coefficient of two ranges.\",\"Z/I92A\":\"Calculates the cosecant of an angle in radians.\",\"F3vbYA\":\"Calculates the cosine of an angle in radians.\",\"DWXWnA\":\"Calculates the cotangent of an angle in radians.\",\"I4onew\":\"Calculates the hyperbolic cosecant of a value.\",\"NXF/+Q\":\"Calculates the hyperbolic cosine of a value.\",\"52DrQw\":\"Calculates the hyperbolic cotangent of a value.\",\"8yOC2A\":\"Calculates the hyperbolic secant of a value.\",\"CXS+fg\":\"Calculates the hyperbolic sine of a value.\",\"ki5b+w\":\"Calculates the hyperbolic tangent of a value.\",\"yqyQhA\":\"Calculates the interest rate per period\",\"YbdwpA\":\"Calculates the inverse cosine of a value, in radians.\",\"67FNkg\":\"Calculates the inverse cotangent of a value, in radians.\",\"VhaXdQ\":\"Calculates the inverse hyperbolic cosine of a value.\",\"tXhjDg\":\"Calculates the inverse hyperbolic cotangent of a value.\",\"NF9wUA\":\"Calculates the inverse hyperbolic sine of a value.\",\"jUL7Gw\":\"Calculates the inverse hyperbolic tangent of a value.\",\"SPVXAg\":\"Calculates the inverse sine of a value, in radians.\",\"aa+wMQ\":\"Calculates the inverse tangent of a value, in radians.\",\"qTPDXw\":\"Calculates the inverse tangent of x and y coordinates, in radians.\",\"G5txlA\":\"Calculates the logarithm of a number to the specified base.\",\"zLndUw\":\"Calculates the natural logarithm of a number.\",\"WOh05w\":\"Calculates the secant of an angle in radians.\",\"8BQlNQ\":\"Calculates the sine of an angle in radians.\",\"brlOqA\":\"Calculates the square root of a value multiplied by π.\",\"hLxQUQ\":\"Calculates the tangent of an angle in radians.\",\"qGb3aQ\":\"Capitalizes the first letter of each word in text.\",\"at5mtg\":\"Check if the value is empty.\",\"Js/1VQ\":\"Checks for any error except #N/A.\",\"vVcG+g\":\"Checks for the #N/A error. Can replace it with a custom value.\",\"JZNFRA\":\"Checks formulas for errors. Can replace errors with a custom value.\",\"ygvJrg\":\"Checks if the number is even.\",\"M1OjIw\":\"Checks if the number is odd.\",\"EOQAlg\":\"Checks if the value is TRUE or FALSE.\",\"DAE25g\":\"Checks if the value is a cell reference.\",\"1i6N5w\":\"Checks if the value is a number.\",\"pLIEIg\":\"Checks if the value is not text.\",\"8sorvw\":\"Checks if the value is text.\",\"ZIhetQ\":\"Checks if the value is the #N/A error.\",\"z6237A\":\"Checks multiple criteria. Gives value based on the first true criteria.\",\"F7KAQw\":\"Checks whether a criteria is met. Gives one value if true and another if false.\",\"ls1oQA\":\"Combines an hour, minute, and second into a time.\",\"KyOXKw\":\"Combines text from different cells.\",\"u9D8CQ\":\"Combines two numbers, keeping the bits set in both.\",\"A35vuQ\":\"Combines two numbers, keeping the bits set in either.\",\"BHLDiA\":\"Combines two numbers, keeping the bits set in only one.\",\"/2+OaA\":\"Compares two text strings for case-sensitive equality.\",\"JwnsBA\":\"Converts a Roman numeral to an Arabic number.\",\"3/fncg\":\"Converts a binary number to decimal.\",\"uQcuvQ\":\"Converts a binary number to hexadecimal.\",\"Ggy3mg\":\"Converts a binary number to octal.\",\"qMQCLA\":\"Converts a decimal number to binary.\",\"twTv0w\":\"Converts a decimal number to hexadecimal.\",\"KITw+A\":\"Converts a decimal number to octal.\",\"+lchxQ\":\"Converts a hexadecimal number to binary.\",\"IUjJWg\":\"Converts a hexadecimal number to decimal.\",\"wmvBiA\":\"Converts a hexadecimal number to octal.\",\"DP2ATQ\":\"Converts a number to text in a given base.\",\"//C0kQ\":\"Converts a value to a number.\",\"U5lElw\":\"Converts a year, month, and day into a date.\",\"qU+9oQ\":\"Converts all lowercase letters to uppercase.\",\"iBKmhA\":\"Converts all uppercase letters to lowercase.\",\"1KwBTA\":\"Converts an Arabic number to a Roman numeral as text.\",\"9f7nIg\":\"Converts an angle from degrees to radians.\",\"dXmVaQ\":\"Converts an angle from radians to degrees.\",\"bf1Fvw\":\"Converts an octal number to binary.\",\"n4Eh/A\":\"Converts an octal number to decimal.\",\"irvd5Q\":\"Converts an octal number to hexadecimal.\",\"XKGH4g\":\"Converts text in a given base to a decimal number.\",\"lJfBtg\":\"Converts text to numbers.\",\"8MC7NQ\":\"Counts the cells with any data.\",\"oIv25Q\":\"Counts the cells with numbers.\",\"GhP5GA\":\"Counts the number of cells that meet a specified condition.\",\"kgOhOg\":\"Counts the number of cells that meet multiple specified conditions.\",\"hMw7aQ\":\"Counts the number of empty cells in a specified range.\",\"rOG4RQ\":\"Counts the number of unique values in a specified range.\",\"Gmryjg\":\"Counts the working days between two dates with custom weekends.\",\"jVOyKw\":\"Counts the working days between two dates.\",\"mcEQ9A\":\"Determines if there’s an error.\",\"M0/1dw\":\"Estimates standard deviation based on a sample.\",\"q9Ok2g\":\"Estimates variance based on a sample.\",\"SRTiNw\":\"Finds monthly payments based on interest rate, number of payments, and loan amount\",\"ov07pg\":\"Finds the average of a set of numbers.\",\"/5m7DQ\":\"Finds the future value of an investment or loan\",\"MvkKiw\":\"Finds the largest value.\",\"HMeuTg\":\"Finds the most frequently occurring value in a range of numbers.\",\"TjYcWg\":\"Finds the nth largest value in a set of numbers.\",\"WAP4YA\":\"Finds the nth smallest value in a set of numbers.\",\"HSWMvg\":\"Finds the number in the middle of a set of numbers.\",\"m81pAQ\":\"Finds the peri

2ods needed to pay off a loan or reach a goal\",\"RdJGsg\":\"Finds the position of one text string within another, case-insensitively.\",\"Lkx4/g\":\"Finds the position of one text string within another, case-sensitively.\",\"UjumIw\":\"Finds the present value of an investment or loan\",\"2/8ILQ\":\"Finds the smallest value.\",\"cNhTsA\":\"Finds the value corresponding to a percentile in a set of numbers.\",\"y6aHXQ\":\"Gives 1, 0, or -1 reflecting the sign of a number.\",\"ZsgTfw\":\"Gives a date a number of months before or after another date.\",\"N0/dtw\":\"Gives a date a number of working days before or after another date.\",\"BkiWCg\":\"Gives a number that matches the kind of error.\",\"xvPvgA\":\"Gives a number that shows the kind of value.\",\"lq3zYw\":\"Gives a working day before or after a date with custom weekends.\",\"qeR5Jw\":\"Gives the ISO week number of a date.\",\"H0sxOw\":\"Gives the content of a cell, based on the row and column provided.\",\"t3r0dg\":\"Gives the day of a date.\",\"6CyJUg\":\"Gives the day of the week of a date.\",\"cT9jOw\":\"Gives the difference between two dates in years, months, or days.\",\"je34hQ\":\"Gives the fraction of a year between two dates.\",\"MnQFqA\":\"Gives the hour of a time.\",\"cCLKyA\":\"Gives the last day of the month a number of months before or after a date.\",\"4K3ehg\":\"Gives the minute of a time.\",\"Vam+FA\":\"Gives the month of a date.\",\"1G5NUA\":\"Gives the number of days between two dates based on a 360-day year.\",\"P2CRhA\":\"Gives the number of days between two dates.\",\"WN757g\":\"Gives the number of permutations of k items chosen from n.\",\"/EBfHQ\":\"Gives the number of permutations with repetitions of k items from n.\",\"VVgnDA\":\"Gives the positive square root.\",\"9Gg1Mg\":\"Gives the relative position of an item in a range that matches a specified value.\",\"89HroA\":\"Gives the remainder of a division. Sign follows the divisor.\",\"huj66w\":\"Gives the second of a time.\",\"OlxWEg\":\"Gives the week number of a date.\",\"zPqQHw\":\"Gives the year of a date.\",\"SRLplQ\":\"Horizontal lookup. Searches a table and returns values from a specified row.\",\"FXVDhA\":\"Joins several text strings into one text string.\",\"6yN5oQ\":\"Joins text values with a delimiter, optionally skipping empty values.\",\"SUASIw\":\"Multiplies the numbers in the selected cells.\",\"bbUwgg\":\"Raises a number to a power.\",\"7e/ykw\":\"Removes leading, trailing, and repeated spaces from text.\",\"MECRCA\":\"Removes non-printable characters from text.\",\"J0SJZg\":\"Repeats text a given number of times.\",\"KValoQ\":\"Replaces occurrences of one text string with another.\",\"AytKEQ\":\"Returns TRUE if all arguments are TRUE.\",\"p4oyCg\":\"Returns TRUE if an odd number of arguments are TRUE.\",\"YAYu0Q\":\"Returns TRUE if any argument is TRUE.\",\"yoFtDQ\":\"Returns characters from the middle of a text string.\",\"zzuA3Q\":\"Returns e raised to the power of a number.\",\"h/X3og\":\"Returns text after a delimiter.\",\"h7wpzg\":\"Returns text before a delimiter.\",\"gEb1Aw\":\"Returns text from any specified value, optionally with strict quoting.\",\"maDjOw\":\"Returns the Unicode character for the given code point.\",\"JpRivQ\":\"Returns the Unicode code point of the first character of text.\",\"vzc+ug\":\"Returns the Windows-1252 numeric code of the first character of text.\",\"kiCZfQ\":\"Returns the character for the given code in the Windows-1252 character set.\",\"zxSzLg\":\"Returns the double factorial of a number (product of every other integer down to 2 or 1).\",\"u6y6JQ\":\"Returns the factorial of a number.\",\"1gyKsg\":\"Returns the first characters.\",\"7JGq0Q\":\"Returns the greatest common divisor of the supplied integers.\",\"HhszWQ\":\"Returns the integer part of a division. Truncates toward zero.\",\"MqIlFw\":\"Returns the last characters.\",\"QPZjYQ\":\"Returns the least common multiple of the supplied integers.\",\"enjsIQ\":\"Returns the number of characters.\",\"nZng0A\":\"Returns the number of combinations of k items from n.\",\"qS9Sww\":\"Returns the number of combinations with repetitions of k items from n.\",\"VNCD2A\":\"Returns the text referred to by value.\",\"qW7ibw\":\"Returns the value of the mathematical constant π (pi).\",\"moRadA\":\"Reverses the logic of its argument.\",\"+in5zw\":\"Rounds a number away from zero to the nearest even integer.\",\"+IzNpQ\":\"Rounds a number away from zero to the nearest odd integer.\",\"D4mhWA\":\"Rounds a number down to the nearest integer or multiple of significance.\",\"gN1P1g\":\"Rounds a number down to the nearest integer.\",\"uu7Uhw\":\"Rounds a number down to the nearest multiple of a given significance.\",\"u9ZMoA\":\"Rounds a number down to the nearest multiple of significance, regardless of sign.\",\"kUEOwQ\":\"Rounds a number down, towards zero.\",\"eS19AA\":\"Rounds a number to a specified number of decimal places and returns it as text.\",\"XbB70g\":\"Rounds a number to the nearest multiple of a given factor.\",\"Dg2XTw\":\"Rounds a number up to the nearest integer or multiple of significance.\",\"XtfWtw\":\"Rounds a number up to the nearest multiple of a given significance.\",\"7wd5SA\":\"Rounds a number up to the nearest multiple of significance, regardless of sign.\",\"W9EsAg\":\"Rounds a number up to the nearest multiple of significance, regardless of sign.\",\"h3Jymg\":\"Rounds a number up, away from zero.\",\"VdIrCw\":\"Rounds the number to the specified number of decimal places.\",\"vpH+/g\":\"Searches a table and returns matching values. If no match exists, it can return the closest match.\",\"Nq1FPw\":\"Shifts a number left by the given number of bits.\",\"ZQbkzA\":\"Shifts a number right by the given number of bits.\",\"cUoq1Q\":\"Truncates a number toward zero at the specified number of decimal places.\",\"XILGzw\":\"Vertical lookup. Searches a table and returns values from a specified column.\"}");
3const cmsg=globalThis["cmsg"]=globalThis["cmsg"]||{};
4
5const loaded=cmsg["loaded"]=cmsg["loaded"]||{};
6loaded["50306_en"]=1;
7const strings=cmsg["strings"]=cmsg["strings"]||{};
8strings["en"]=strings["en"]?Object.assign(strings["en"],messages):messages;
9})();