Re: Working with formulas

[parjo <warozzo gmail com>]

Hal Ashburner-2 wrote:
> On 16/12/2009 12:41 PM, parjo wrote:
> > Hi,
> >
> > I've only using GnuMeric for 3 months, and came to an obstacle. I don't
> > know
> > how to formulate this in GnuMeric:
> >
> > if (j1=4 or j1=3 or j1=2)
> >      then k=1000
> > elseif (j1=1)
> >      then k=500
> > else
> >      k=0
> >
> > Would someone enlightenment with this problem?
> >    
> =IF(OR(J1=4, j1=3, j1=2),1000,IF(j1=1,500,0))
> will evaluate that cell as k according to your rules above.
> Generally it's not a bad idea to break these down into multiple cells to 
> make them easier to read.
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list

Thank you, it's working.
-- 
View this message in context: http://old.nabble.com/Working-with-formulas-tp26803731p26820947.html
Sent from the GnuMeric mailing list archive at Nabble.com.