Re: New User



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/




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