Here is the spreadsheet we did in class: SSS worksheet-SMW 2013

If you find any problems, please email Edie.

OpenOffice Users: You were having trouble with the CONVERT function. It is slightly different in OpenOffice. The syntax is:

=CONVERT_ADD(number;”text”;”text”)

so the following formula should convert the value of B12 from inches to cm.

=CONVERT_ADD(B12;”in”;”cm”)

It worked on my copy of OpenOffice, but do email me if it doesn’t work for you.