IF statement, delimiters, blanks in spreadsheet
|
06-10-2014, 04:04 AM
Post: #2
|
|||
|
|||
RE: IF statement, delimiters, blanks in spreadsheet
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. |
|||
« Next Oldest | Next Newest »
|
Messages In This Thread |
IF statement, delimiters, blanks in spreadsheet - resolved - 06-10-2014, 03:44 AM
RE: IF statement, delimiters, blanks in spreadsheet - Michael de Estrada - 06-10-2014 04:04 AM
RE: IF statement, delimiters, blanks in spreadsheet - Tim Wessman - 06-10-2014, 02:19 PM
RE: IF statement, delimiters, blanks in spreadsheet - resolved - 06-10-2014, 04:18 AM
RE: IF statement, delimiters, blanks in spreadsheet - Michael de Estrada - 06-10-2014, 04:28 AM
RE: IF statement, delimiters, blanks in spreadsheet - cyrille de brébisson - 06-10-2014, 05:51 AM
|
User(s) browsing this thread: 1 Guest(s)