| View previous topic :: View next topic |
| Author |
Message |
jwb1
General User
Joined: 20 Aug 2011
Posts: 14
Location: PA
|
 Posted: Sat May 26, 2012 5:58 pm Post subject: if and vlookup |
 |
|
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 |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sun May 27, 2012 2:34 am Post subject: |
|
|
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 http://forum.openoffice.org |
|
| Back to top |
|
|
jwb1
General User
Joined: 20 Aug 2011
Posts: 14
Location: PA
|
| Posted: Sun Jun 03, 2012 1:14 pm Post subject: |
|
|
 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. |
|
| Back to top |
|
|
foff44
Newbie
Joined: 31 May 2012
Posts: 1
|
| Posted: Mon Jun 04, 2012 2:22 am Post subject: |
|
|
| 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 |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Mon Jun 04, 2012 3:00 am Post subject: |
|
|
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 http://forum.openoffice.org |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Mon Jun 04, 2012 6:42 am Post subject: |
|
|
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 http://forum.openoffice.org |
|
| Back to top |
|
|
|
