Main Menu
Search

Advanced Search
or try google search
HM's Goodies and such
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
71 user(s) are online (34 user(s) are browsing Forum)

Members: 0
Guests: 71

more...
advertisements
Your
AD
Here!
» Sign up Today!!
Report message:*
 

Re: Any Spreadsheet Wizards?

Subject: Re: Any Spreadsheet Wizards?
by drunkendragon on 2017/6/10 19:30:39

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...
»
»
»