Claris Works Spreadsheets and ClarisImpact Tables share the same set of calculation functions. While these features are documented in Appendix A of the Claris Works User's Guide, ClarisImpact makes no mention of these calculation functions. Listed below are all the functions and their syntax available in both ClarisImpact 1.0 and Claris Works 2.0.
ABS(number)
ACOS(number)
ALERT(value)
AND(logical1, logical2,...)
ASIN(number)
ATAN(number)
ATAN2(x_number, y_number)
AVERAGE(number1, number2,...)
BEEP()
CHAR(number)
CHOOSE(index,value1,value2,...)
CODE(text)
COLUMN({cell})
CONCAT(text1, text2,...)
COS(number)
COUNT(value1, value2,...)
COUNT2(searchvalue, value1,...)
DATE(year, month, day)
DATETOTEXT(serial_number {,format_number})
DAY(serial_number)
DAYNAME(number)
DAYOFYEAR(serial_number)
DEGREES(radians_number)
ERROR()
EXACT(text1,text2)
EXP(number)
FACT(number)
FIND(find_text, in_text {,start_offset})
FRAC(number)
FV(rate, nper, pmt, {pv}, {type})
HLOOKUP(lookup_value, compare_range, index {,method})
HOUR(serial_number)
IF(logical, true_value, false_value)
INDEX(range, row, column)
INT(number)
IRR(range {,guess})
ISBLANK(value)
ISERROR(value {,error_type})
ISLOGICAL (value)
ISNA(value)
ISNUMBER(value)
ISTEXT(value)
LEFT(text, number_of_characters)
LEN(text)
LN(number)
LOG(number {,base})
LOG10(number)
LOOKUP(lookup_value, compare_range, result_range {,method})
LOWER(text)
MACRO(text)
MATCH(lookup_value, compare_range, {type})
MAX(number1, number2,...)
MID(text, start_position, number_of_characters)
MIN(number1, number2,...)
MINUTE(serial_number)
MIRR(safe, risk, values,É)
MOD(number, divisor_number)
MONTH(serial_number)
MONTHNAME(number)
NA()
NOT(logical)
NOW()
NPER(rate,pmt,pv{,fv}{,type})
NPV(interest_rate,payment1,payment2,...)
NUMTOTEXT(number)
OR(logical1, logical2,...)
PI()
PMT(rate,nper,pv{,fv}{,type})
PRODUCT(number1, number2,...)
PROPER(text)
PV(rate,nper,pmt{,fv}{,type})
RADIANS(degrees_number)
RAND({number})
RATE(fv,pv,term)
REPLACE(old_text, start_num, num_chars, new_text)
REPT(text, #_of_times)
RIGHT(text, number_of_characters)
ROUND(number, number_of_digits)
ROW({cell})
SECOND(serial_number)
SIGN(number)
SIN(number)
SQRT(number)
STDEV(number1, number2,...)
SUM(number1, number2,...)
TAN(number)
TEXTTODATE(date_text)
TEXTTONUM(text)
TEXTTOTIME(time_text)
TIME(hour,minute,second)
TIMETOTEXT(serial_number {,format})
TRIM(text)
TRUNC(number)
TYPE(value)
UPPER(text)
VAR(number1, number2,...)
VLOOKUP(lookup_value, compare_range, index {,method})
WEEKDAY(serial_number)
WEEKOFYEAR(serial_number)
YEAR(serial_number)