Re: Any Spreadsheet Wizards?

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

This Post was from: http://heromorph.com/heromorph2/newbb/viewtopic.php?forum=1&topic_id=3661&post_id=41972