[University - Computers] Question about Open Office versus MS Office

[devonin]

So I'm in this computer science course to satisfy my last sciences requirement to graduate, and it seems to be centred primarily around MS Excel. Problem is, I use Open Office, and simply don't own a copy of the MS Office Suite at all.

The first project has already come up and I've already run into the first issue with incompatibility, namely =IF statements.

=IF(H9>60, "pass", "fail")

This seems to me to be the correct way to phrase it for MS Excel. It will compare the number in H9 to 60, if it is greater, print "pass" in the cell, if it is less, print "fail" in the cell.

If anyone happens to be familiar with Open Office, my trawling through its much less robust help system hasn't shown me what particular syntax it wants me to be using, so any assistance on that would be helpful. Thanks.