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 > > _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
