can OO calc make this formula?

[timknoop]

i am new to Calc or any spreadsheet system.
i want to create a formula (since i cannot find it in the existing lists) that does this:

if (A1) is greater than (B1) return "over", if (B1) is greater than (A1) return "under", if equal, return "--" or "="

can this be done and how do i do it?

[Ed]

You could use the IF function. The structure is IF(test ; what to return if true ; what to return if false). The what to return if true and/or what to return if false can be another IF function. If you want to return text rather than a formatted number of the result of a formula, the text should be in quotation marks.

Here you could use something like

[keme]

You could also use formatting for the display, and have numeric content in the cell.
Formula =A1-B1
Format code: "Over";"Under";"--"

The cell will then contain the actual difference, which can be used in further calculations, but will display the text indicating "direction" of the difference only.

If this is useful, also see if you can make use of the SIGN() function. (See explanation in the help system.)

[timknoop]

Ed, very helpful. thank you.