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 <[EMAIL PROTECTED]> 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 > <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 > >> [email protected] > >> http://mail.gnome.org/mailman/listinfo/gnumeric-list > >> > >> > > > > -- > Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ > _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
