"SOLVER" function as in Excel

[rawi]

Quote:is it possible in the "spreadsheet" APP to use an "IF THEN ELSE" statement as in EXCEL?

I did not find a direct way, but a somewhat indirect.
Suppose you want to compare the number in cell A1 with the number in cell A2 and you want to have the number 50 in cell B1 if A1 > A2, else 20.
Then you type in a cell not A1, A2 or B1 (e.g. A3): =A1>A2
If A1>A2 is true you will get 1 in A3, else 0.
So you have to put in cell B1: =A3*30+20 to get the result.