Re: New User

["Uri David Akavia" <uridavid akavia gmail com>]

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