Question about Works 4.5 database

Jeffrey Needle

unread,

Mar 2, 2011, 6:20:02 AM3/2/11

to

Hello, all. I have a question. I'm trying to create a formula in a
database column that has a complex structure. It is something like this:

=if(condition AND condition,result, result)

It's the first condition that's giving me problems. How do you place
multiple conditions in the first part of the formula? Putting "AND"
creates an error.

Is it even possible to do this in Works 4.5?

Thanks.

Guido Ostkamp

unread,

Mar 2, 2011, 5:54:36 PM3/2/11

to

I doubt that you are talking of a "database" in the sense of "Works
database" since a Works database doesn't support formulas at all.

Instead it appears you mean a Works spreadsheet. There you could try
something like

=if(condition1, if(condition2, result1, result2), result2)

By the way: This newsgroup is effectively dead, since Microsoft has
discontinued hosting it.

Regards

Guido

Guido Ostkamp

unread,

Mar 2, 2011, 6:02:57 PM3/2/11

to

Guido Ostkamp <gueltig-bis...@nurfuerspam.de> wrote:
>> Is it even possible to do this in Works 4.5?

Just forgot to mention it:

The possibilities in Works 4.5 are rather limited and the product is
very outdated and might not work flawlessly in modern Windows variants
like XP or later. 4.5 however was the last really integrated release
whereas later Works version appeared to be split into separate
programs, sometimes with the Works text processor replaced by Word.

If you need something better for free, I recommend getting LibreOffice
<http://www.libreoffice.org>, a fork of OpenOffice.org. It is a full
featured Office, there is no need to buy MS-Office.

Regards

Guido

Jeffrey Needle

unread,

Mar 2, 2011, 10:55:26 PM3/2/11

to

Actually, you can use formulas just fine in the database. Just enter
them into a field, and they work wonderfully. The help screens are very
good in guiding you through the process. I tried nesting the conditions
as suggested, but Works couldn't handle it. Thanks.

Jeffrey Needle

unread,

Mar 2, 2011, 10:56:50 PM3/2/11

to

Oddly, the database in LibreOffice (nee OpenOffice) is *less able to
handle formulas* than Works! No formulas at all, and thus worthless for
my uses.

Thanks for the suggestion, but it won't work for me. And LibreOffice
takes so damned much space, is so slow on my system. Nah, not for me.

Thanks again.

Guido Ostkamp

unread,

Mar 6, 2011, 9:53:11 AM3/6/11

to

Jeffrey Needle <jeff....@gmail.com> wrote:
> Actually, you can use formulas just fine in the database. Just
> enter them into a field, and they work wonderfully. The help
> screens are very good in guiding you through the process. I tried
> nesting the conditions as suggested, but Works couldn't handle it.
> Thanks.

ok, I checked out Works DB and found you are correct though I couldn't
believe it. According to the help pages you could try something like

=IF(AND(condition1, condition2), result1, result2)

I have the German version of Works here with different German keywords
and semicolon instead of comma, but I guess the above could work in
the English version. In my version it did with my keywords and some
simple conditions like "x=5".

Regards

Guido

Kevin James

unread,

Mar 20, 2011, 7:28:34 AM3/20/11

to

Hi Jeff,

Works operates on 'nested conditions' too.

If you provide further details then perhaps I can help.

HTH,
--
Kevin

"Jeffrey Needle" <jeff....@gmail.com> wrote in message
news:ikn3ff$1vo$1...@news.eternal-september.org...