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

Names and IF/THENs

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


Joined: 29 Jun 2012
Posts: 2

PostPosted: Fri Jun 29, 2012 3:45 pm    Post subject: Names and IF/THENs Reply with quote

Hello, first post.

I understand how to use IF ok but I don't know how to use it if the cell I am referencing is a word instead of a number. Or how to move to another row if the IF query is false and retry the formula.

I am simplifying the inventory sheet at the bar I work at and after the count of bottles is entered into a cell I want the order quantity to be calculated under the proper supplier heading. For example, I want to say on G3:

IF(A3='supplierA';print D3;IF('notsupplierA';goto next row)

That way all liquor coming from CS is is a nice column with the amount to buy and all liquor from DW is in a column.

I don't mind figuring this out on my own, I have a little code experience, but I just don't know where to look as I usually just use the spreadsheet for much easier calcs.
Back to top
View user's profile Send private message
ozzie
OOo Advocate
OOo Advocate


Joined: 29 Jul 2010
Posts: 400
Location: victoria

PostPosted: Fri Jun 29, 2012 3:52 pm    Post subject: Reply with quote

Code:
=IF(A3="tiger";D3;"")

It won't move you to the next row. It will just leave an empty space.
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
Alex3
Newbie
Newbie


Joined: 26 Aug 2010
Posts: 4

PostPosted: Sun Jul 01, 2012 8:45 am    Post subject: Reply with quote

Is this what you're looking for?:
=VLOOKUP("supplierA";A$3:D$12;4;0)
Back to top
View user's profile Send private message
kbakermemphis
Newbie
Newbie


Joined: 29 Jun 2012
Posts: 2

PostPosted: Sun Jul 01, 2012 2:19 pm    Post subject: Reply with quote

That looks like the ticket Alex3. I will have to play with this a little to get what I want but I believe I can figure the rest of it out with this. Thank you so much.

Thank you as well ozzie.
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Tue Jul 10, 2012 2:14 am    Post subject: Reply with quote

Depending on your data layout and the level of summation you are after, you may also make use of the data pilot.
Back to top
View user's profile Send private message
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