Re: New User

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

Sure.
Two things - when you continue a thread that started on the list, use
"Reply All" so the list is still informed.
As for your specific reply, I'll be happy to help. Email the list, and
if I can help, I'll reply.

You're welcome,

Uri David

On 9/5/07, jackie_freeman <jackie_freeman sbcglobal net> wrote:
> Dear Uri:
>
> Thank you greatly for the assistance in solving my problem.  It achieved
> the exact results I was looking for.
>
> As I am still learning Gnumeric, I hope I may request your knowledge to
> further expand my understanding.
>
> Thanks again,
>
> JF
>
> On Mon, 03 Sep 2007 14:30:45 -0500, Uri David Akavia
> <uridavid akavia gmail com> wrote:
>
> > 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
>
>
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/