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

if and vlookup

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


Joined: 20 Aug 2011
Posts: 15
Location: PA

PostPosted: Sat May 26, 2012 5:58 pm    Post subject: if and vlookup Reply with quote

I am trying to say if column 1 = "a","b", or "c" then cell d2="x",cell d2="y", cell d3="z" , & cell d4="ab" what is the proper way to write this formula?

Thank you

Jim
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun May 27, 2012 2:34 am    Post subject: Reply with quote

The proper way would require some learning. We are not here to answer the same most basic questions over and over again. Invest some of your own time and effort and come back when you have a clear question.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
jwb1
General User
General User


Joined: 20 Aug 2011
Posts: 15
Location: PA

PostPosted: Sun Jun 03, 2012 1:14 pm    Post subject: Reply with quote

Sad With all due respect sir, after 3 brain surgeries, I am trying to relearn how to do this. I used lotus and Excel for IBM for 16 years, I used OpenOffice at home. IBM has since put me on long-term disability because of my memory problems. Everytime I ask a question on the open office forum, I then journal it and the answer so I don't have to ask the question again. I know with my memory problems I will forget the correct way of doing it. Sad
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
foff44
Newbie
Newbie


Joined: 31 May 2012
Posts: 1

PostPosted: Mon Jun 04, 2012 2:22 am    Post subject: Reply with quote

Villeroy wrote:
The proper way would require some learning. We are not here to answer the same most basic questions over and over again. Invest some of your own time and effort and come back when you have a clear question.


If he learned the program he would know how to write this formula which I would say is fairly involved , then he wouldn't have to come here and get spoken to like that....

Also I see that you are a "super User" do you want to keep all that knowledge to yourself......
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Jun 04, 2012 3:00 am    Post subject: Reply with quote

Why should I post the 1365th variant of the same IF-formula? This is becoming more and more ridiculous.
I just responded because nobody else did.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Jun 04, 2012 6:42 am    Post subject: Reply with quote

Today's version of the same shit: http://www.oooforum.org/forum/viewtopic.phtml?t=162954
This is so trivial. Everybody can do that with a little bit of thinking and playing around.
In the week Jim waited for spoon feeding he could have learned everything about spreadsheets.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
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