OpenOffice spreadsheet formula synyax

I'm brand new to linux and OpenOffice. I'm having a little trouble with the syntax for a formula in my OO spreadsheet.

I want to test two cells in sheet one in a cell in sheet2 and if both conditions are true, enter the value from a third cell in sheet one into a specified cell in sheet two. If false, then enter a value from a different cell in sheet one.

In general terms, here's what I want:

IF the first three characters in a sheet one cell are abc AND the first four characters in a different sheet one cell are the same as the first four characters in a specified cell in sheet two THEN insert the value from yet another sheet one cell into the cell in sheet two where the formula resides.

Some of the cell references are absolute, others are relative.

The formula which works in my QuatroPro spreadsheet is as follows:

@IF(LEFT(A:$C70,3)=”Jan”#AND#@LEFT(A:$F70,4)=@LEFT(T$56,4),A:$AR70,A:$C$2)

I managed to move most of my spreadsheet from QuatroPro to OO by first converting it to Excel and then converting the Excel file to OO. Although I had to fiddle with some of the row and column settings it mostly worked, except for this formula.

Any help would be greatly appreciated. The help function in OO for Logical functions was a bit helpful but I was unable to get the combinations right.`