IF statement, delimiters, blanks in spreadsheet

[Michael de Estrada]

Try using this:

=IFTE(A2=0,"",ATAN(B2/A2))

You need to use the IFTE form of the IF statement in a spreadsheet. Note that the Prime spreadsheet treats a blank cell as zero for a numerical comparison. Also, it is ok to use lower case a2 for the cell address, but I like to use capital letters for consistency with the default cell column names.