Re: New User



Hi.
First, you can combine the two formulas.

=IF(AND(condition1, condition2), 1, 0)

That will save you a row there.

I think that you can also format the output cells (Ctrl-1, I believe,
but you can check the menus), and try to find some kind of formatting
that turns TRUE into 1 and FALSE into 0.

Yours,

Uri David Akavia

On 9/3/07, jackie freeman <jackie_freeman sbcglobal net> wrote:
Hello,

I am a new user of the 1.6.3 version.  My experience consists only of using
MSW spreadsheet of which I now use GNUMERIC with great delight.  It is
proving challenging to me, but I'm slow & steady anyway.

My current project has me using the "and" function which returns
appropriately with "true or false", which I then use the "IF" function to
convert to "1 or 0", which uses an additional row to arrive at the simple "1
or 0" I'm looking for.

Please excuse my inexperience and offer me a solution that arrives with the
numbers in one formula so as to save the complications.

I do hope someone will have pity on this old gentleman & respond in kind.

JF


_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list





[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]