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.