OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Can you use "AND" & "OR" operators i

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
contriver
General User
General User


Joined: 27 Mar 2007
Posts: 5

PostPosted: Mon Jun 18, 2007 8:33 am    Post subject: Can you use "AND" & "OR" operators i Reply with quote

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
View user's profile Send private message
acknak
Moderator
Moderator


Joined: 13 Aug 2004
Posts: 4295
Location: ~ 40°N,75°W

PostPosted: Mon Jun 18, 2007 10:43 am    Post subject: Reply with quote

No operators, only functions: AND(), OR(), ...
Back to top
View user's profile Send private message
squenson
Super User
Super User


Joined: 09 Mar 2007
Posts: 690
Location: Nis, Serbia

PostPosted: Mon Jun 18, 2007 10:43 am    Post subject: Reply with quote

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
View user's profile Send private message
andypaxo
Newbie
Newbie


Joined: 18 Jun 2007
Posts: 3

PostPosted: Mon Jun 18, 2007 10:46 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group