# 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]