Sometimes you have to work with numeric values that are expressed as fractions. For example, 2 3/4 to mean 2.75. ClarisWorks can't sort or do arithmetic when values are expressed this way. To convert the fractions to decimal values, use the following calculation:
Given a ClarisWorks Spreadsheet cell A1 contains a fraction, the following formula will return a decimal equivalent:
=IF(FIND("/",A1,1)=0,A1,LEFT(A1,FIND(" ",A1,1)-1)+ (MID(A1,FIND(" ",A1,1)+1, FIND("/",A1,1)-FIND(" ",A1,1)-1)) / RIGHT(A1,LEN(A1)-FIND("/",A1,1)))
This formula works as long as a space separates the whole part of the number and the fractional part, and a slash (/) is used to express the fraction.
This formula will also work for a ClarisImpact Table.