opencalc: if statements

# list of functions https://wiki.openoffice.org/wiki/Documentation/Reference/Calc_functions
#Open Calc If statement rounding example
# any value >=20 round else same

=IF($Sheet1.F3 >= 20; ROUNDUP($Sheet1.F3/2); $Sheet1.F3)
=IF($Sheet1.F3 >= 20; ROUNDDOWN($Sheet1.F3/2); 0)
=IF(Sheet1.F3=I3)

# search cell A1 by substring return 1 for true, 0 for false
=IF(ISNUMBER(SEARCH("stringhere"; A1)); 1; 0)
# search cell for multiple keys return 1 if true 0 if false
=IF(ISNUMBER(AND(SEARCH("WOMENS"; D25); SEARCH("NFL"; D25))); 1; 0)

=IF(OR(ISNUMBER(SEARCH("Bag", B1)), ISNUMBER(SEARCH("Purse", B1))),1, 0)