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