S h e e t
COUNTA(value1,value2,...)
Counts how many values are in the list of arguments.
COUNTBLANK(range)
Counts the number of blank cells within a range.
DATE(year,month,day)
Returns the serial number of a particular date.
DATEVALUE(date_text)
Converts a date in the form of text to a serial number.
DAY(serial_number)
Converts a serial number to a day of the month.
DDB(cost,salvage,life,period,factor)
Returns the depreciation of an asset for a specified period using
the double declining balance method or some other method
you specify.
DEGREES(angle)
Converts radians to degrees.
ERROR.TYPE(error_val)
Returns a number corresponding to an error type.
EXACT(text1,text2)
Checks if two text values are identical.
EXP(number)
Returns e raised to the power of a given number.
FACT(number)
Returns the factorial of a number.
False( )
Returns the logical value FALSE.
FIND(find_text,within_text,start_num)
Finds one text value within another (case sensitive) one.
FV(rate,nper,pmt,pv,type)
Returns the future value of an investment.
HLOOKUP(lookup_value,table_array,row_index_num,...)
Looks in the top row of an array and returns the value of the
indicated cell.
HOUR(serial_number)
Converts a serial number to an hour.
IF(logical_test,value_if_true,value_if_false)
Specifies a logical test to perform.
INDEX(reference,row_num,column_num)
Uses an index to choose a value from a reference.
INDIRECT(reference,A1)
Returns the reference of a text.
INT(number)
Rounds a number down to the nearest integer.
IRR(value,guess)
Returns the internal rate of return for a series of cash flows.
ISBLANK(value)
Returns TRUE if the value is blank.
ISERR(value)
Returns TRUE if the value is any error except #N/A.
ISERROR(value)
Returns TRUE if the value is any error value.
ISLOGICAL(value)
Returns TRUE if the value is a logical value.
ISNA(value)
Returns TRUE if the value is the #N/A error value.
ISNONTEXT(value)
Returns TRUE if the value is non text.
ISNUMBER(value)
Returns TRUE if the value is a number.
ISTEXT(value)
Returns TRUE if the value is a text.
LEFT(text,num_chars)
Returns the leftmost characters from a text value.
LEN(text)
Returns the number of characters in a text string.
LN(number)
Returns the natural logarithm of a number.
LOG10(number)
Returns the base 10 logarithm of a number.
LOOKUP( )
Returns a value either from a one row or one column range,
or from an array.
LOWER(text)
Converts text to lowercase.
MAX(number1,number2,...)
Returns the maximum value in a list of arguments.
MID(text,start_num,num_chars)
Returns a specific number of characters from a text string.
MIN(number1,number2,...)
Returns the minimum value in a list of arguments.
MINUTE(serial_number)
Converts a serial number to a minute.
Copyright   2005 Nokia. All Rights Reserved.
48





Actions web hosting footer




 

 

 

 

Home | About Us | Network | Compare Plans | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

Terms Of Service

jsp web hosting

 

Our web partners: Web Hosting PHP Jsp Web Hosting Java Web Hosting Jsp Web Hosting Cheapest Web Hosting  Java Web Hosting

Cheap Web Hosting Java Hosting Cheapest Hosting Quality Web Templates Best Web Templates Web Design Templates

Java Web Hosting Cheap Hosting Cheap Web Hosting Jsp Web Hosting Tomcat Web Hosting

Quality Web Hosting Best Web Hosting Java Web Hosting

Actionswebhosting.com Business web hosting division of Vision Web Hosting Inc. All rights reserved.