Re: [function] MINIF
- From: "Andreas J. Guelzow" <aguelzow pyrshep ca>
- To: Leonel Pereira <leonelcp gmail com>
- Cc: gnumeric-list gnome org
- Subject: Re: [function] MINIF
- Date: Mon, 22 Jun 2009 15:53:41 -0600
On Mon, 2009-06-22 at 17:27 -0300, Leonel Pereira wrote:
Firstly, sorry for my english.
My name is Leonel, I'm studying in a master degree course at
University of Campinas, Brazil. I'm working with combinatorial
optimization and I'm using the gnumeric to data analysis.
I'm using a combination between 'if' and 'min' function creating a
kind of 'minif' like 'someif' or 'countif'. For example I put in a
cell the following expression:
=min(if(A2:A1000=$A$1,B2:B1000,10000))
This function would create a new set where if the value in Ak, with 2
<= k <=1000, is equal to A1, the set would receive the value
corresponding Bk and the value 10000 in the other case.
I was using a gnumeric version 1.6.3 and this association of functions
was possible, but in the computer of my advisor, the gnumeric version
is 1.8.2 and this combination isn't possible. I tried to use other
gnumeric versions and this association wasn't possible.
Can someone help me? Would be possible in the next update, this
association become possible again.
Hi Leonel,
this is still possible, you just need to enter the formula as an array
formula, that means that when you finished editing it you need to type
ctrl-shift-enter.
please let me know whether this worked for you
Andreas
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]