Re: Working with formulas

Hal Ashburner-2 wrote:

On 16/12/2009 12:41 PM, parjo wrote:

I've only using GnuMeric for 3 months, and came to an obstacle. I don't
how to formulate this in GnuMeric:

if (j1=4 or j1=3 or j1=2)
     then k=1000
elseif (j1=1)
     then k=500

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

Thank you, it's working.
View this message in context:
Sent from the GnuMeric mailing list archive at

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]