Main Menu
Search

Advanced Search
or try google search
HM's Goodies and such


Upcoming Challenges
Download Section!
Become a Gold member!

Click Here for more Details about gold Memberships or click the Icon above to donate. Remember to include your Username with donations.
Who's Online
154 user(s) are online (18 user(s) are browsing Forum)

Members: 9
Guests: 145

MarissaSee, Freda32376, ElizaGeral, Samuel96G, SelenaHint, Rosie73554, AndresMcne, DesireeMoo, SantosMend, more...
advertisements
Sign up Today!!

Browsing this Thread:   1 Anonymous Users





Any Spreadsheet Wizards?
The Metal Shinigami (Moderator)
Joined:
2004/12/6 17:15
From Kentucky
Posts: 4958
Level : 51; EXP : 46
HP : 252 / 1261
MP : 1652 / 47432
Offline
Looking for a little help as to how to do this.

I want to create a drop down menu (which is the easy part) that will allow me to select a word from the drop down menu, lets say for example A1 Contains the drop down menu, and populate B1, C1,D1, E1 etc with particular information pertaining to the word selected in A1.

Using Open Office 4.1.3 if that helps.

Posted on: 3 06 17 06:54 am
_________________
Good? I never claimed to be. Just good at what I do, and today that is being evil. - Dark Wanderer.
Create PDF from Post Print


Re: Any Spreadsheet Wizards?
Gold Member
Joined:
2008/11/4 18:41
From Indiana, yeah, Indiana, stop laughing
Posts: 1324
Level : 31; EXP : 42
HP : 0 / 760
MP : 441 / 19905
Offline
I'm NO expert, but I've used multiple (nested) IF statements in EXCEL to do similar things.

Typical IF statement:
=IF (A1=1, "GOOD", "BAD")

Meaning if the number in cell A1 is 1, then the word GOOD appears in the chosen cell. And if the number in A1 is not 1, then the word BAD appears.

Where the condition to be desired is the test-- A1=1
After The first comma then is the TRUE result
and after the second comma is the FALSE result

So "nesting" these would be like that, but changing the False result to another IF statement.

Good example shown here (for grading scale in school):


or check out this link...


office support

Again, not sure about Open Office, but works with some serious forethought in Excel....

And you may have to set up each field to be auto populated with the same formulas... so a lot of labor may be involved... but at least it's a starting point , maybe.

If any of my nerd buddies tell me more, I'll let ya know...

Posted on: 10 06 17 07:30 pm
_________________
Commissioner Gordon: You know I'm violently opposed to police brutality.
Create PDF from Post Print


Re: Any Spreadsheet Wizards?
The Metal Shinigami (Moderator)
Joined:
2004/12/6 17:15
From Kentucky
Posts: 4958
Level : 51; EXP : 46
HP : 252 / 1261
MP : 1652 / 47432
Offline
Cool, thanks!

Posted on: 10 06 17 11:53 pm
_________________
Good? I never claimed to be. Just good at what I do, and today that is being evil. - Dark Wanderer.
Create PDF from Post Print







Post Reply
Account*
Name   Password   Login
Message:*


You cannot start a new topic.
You can view topic.
You cannot reply to posts.
You cannot edit your posts.
You cannot delete your posts.
You cannot add new polls.
You cannot vote in polls.
You cannot attach files to posts.
You cannot post without approval.

[Advanced Search]