EOMONTH What Does It Do? This function will show the last day of the month which is a specified number of months before or after a given date. Syntax
EOMONTH What Does It Do? This function will show the last day of the month which is a specified number of months before or after a given date. Syntax
DELTA What Does It Do ? This function compares two values and tests whether they are exactly the same. If the numbers are the same the result will be 1, otherwise the result is 0. It only works with numbers, text values produce a result of #VALUE. The formatting of the number is not significant, so numbers which appear rounded …
DEC2HEX What Does It Do ? This function converts a decimal number to its hexadecimal equivalent. It can only cope with decimals ranging from -549,755,813,888 to 549,755,813,887. The result can be padded with leading 0 zeros, although this is ignored for negatives. Syntax
GCD What Does It Do ? This function calculates the largest number which can be used to divided all the values specified. The result is always a whole number. Where there is no common divisor the value of 1 is used. Decimal fractions are ignored. Syntax
DEC2BIN What Does It Do ? This function converts a decimal number to its binary equivalent. It can only cope with decimals ranging from -512 to 511. The result can be padded with leading 0 zeros, although this is ignored for negatives. Syntax =DEC2BIN(DecimalNumber,PlacesToPad) The PlacesToPad is optional. Formatting No special formatting is needed.
DMAX What Does It Do ? This function examines a list of information and produces the largest value from a specified column. Syntax
GESTEP What Does It Do ? This function test a number to see if it is greater than or equal to another number. If the number is greater than or equal, the result of 1 will be shown, otherwise 0 is shown. Syntax
HEX2DEC What Does It Do ? This function converts a hexadecimal number to its decimal equivalent. Syntax
ISEVEN What Does It Do ? This function tests a number to determine whether it is even. An even number is shown as TRUE an odd number is shown as FALSE. Note that decimal fractions are ignored. Note that dates can be even or odd. Note that text entries result in the #VALUE! error. Syntax
DGET What Does It Do ? This function examines a list of information and produces one result. If more than one record matches the criteria the error #NUM is shown. If no records match the criteria the error #VALUE is shown. Syntax
Aakhir Kyon is the ultimate Educational & life Changing website. It is clean, super flexible, responsive! This News, Newspaper WordPress theme sets the new standard with endless possibilities, and lifetime updates with newly requested features from our users. And its the most easy-to use theme on the market!
Built by Mr. Amit Gupta HTML5 & CSS3, The clean News design can be used for any type of website: News, Blog, Minimal, Personal, Magazin, Newspaper, Products, etc.