| View previous topic :: View next topic |
| Author |
Message |
contriver
General User
Joined: 27 Mar 2007
Posts: 5
|
 Posted: Mon Jun 18, 2007 8:33 am Post subject: Can you use "AND" & "OR" operators i |
 |
|
| I know how to do the regular "IF" statements like IF(A1>B1;"A1 is bigger";""). But I would like to do something like IF(A1>C1 AND B11>C1;"C1 is smaller than A1 and B1";""). Any ideas? Thanks! |
|
| Back to top |
|
 |
acknak
Moderator
Joined: 13 Aug 2004
Posts: 4295
Location: ~ 40°N,75°W
|
| Posted: Mon Jun 18, 2007 10:43 am Post subject: |
|
|
| No operators, only functions: AND(), OR(), ... |
|
| Back to top |
|
|
squenson
Super User
Joined: 09 Mar 2007
Posts: 690
Location: Nis, Serbia
|
| Posted: Mon Jun 18, 2007 10:43 am Post subject: |
|
|
contriver,
You can use AND and OR operators, but the syntax is a little bit awkward: | Code: | | =IF(AND(A1>C1;B1>C1);"C1 is smaller than A1 and B1";"") |
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<< |
|
| Back to top |
|
|
andypaxo
Newbie
Joined: 18 Jun 2007
Posts: 3
|
| Posted: Mon Jun 18, 2007 10:46 am Post subject: |
|
|
Yep, that's easy.
You would use | Code: | | IF(AND(A1>C1;B11>C1);"C1 is smaller than A1 and B1";"") |
You can find out the form of any function by clicking the "f(x)" button next to the formula entry bar at the top of the spreadsheet, by the way. |
|
| Back to top |
|
|
|
