[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
kbakermemphis
Newbie

Joined: 29 Jun 2012
Posts: 2

 Posted: Fri Jun 29, 2012 3:45 pm    Post subject: Names and IF/THENs 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.
ozzie

Joined: 29 Jul 2010
Posts: 400
Location: victoria

Posted: Fri Jun 29, 2012 3:52 pm    Post subject:

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

It won't move you to the next row. It will just leave an empty space.
_________________
Alex3
Newbie

Joined: 26 Aug 2010
Posts: 4

 Posted: Sun Jul 01, 2012 8:45 am    Post subject: Is this what you're looking for?: =VLOOKUP("supplierA";A\$3:D\$12;4;0)
kbakermemphis
Newbie

Joined: 29 Jun 2012
Posts: 2

 Posted: Sun Jul 01, 2012 2:19 pm    Post subject: 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.
keme
Moderator

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

 Posted: Tue Jul 10, 2012 2:14 am    Post subject: Depending on your data layout and the level of summation you are after, you may also make use of the data pilot.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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