# Re: Working with formulas

• From: parjo <warozzo gmail com>
• To: gnumeric-list gnome org
• Subject: Re: Working with formulas
• Date: Wed, 16 Dec 2009 16:10:01 -0800 (PST)

```

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

_______________________________________________
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.

```