Excell

[Roger Alberto Rodriguez Cortes]

He descargado este programa y no logro abrir las paginas de excell que me 
envían los clientes

Enviado desde Correo para 
Windows

Re: Median Function Used as "Between"

[Beregond , Anders Stenström]

Den 2022-08-23 kl. 15:36, skrev David Stuhr:

Can the Median function in Open Office Spreadsheet be used as a between 
function?


When the following equation is entered

=IF(B12=MEDIAN(120;129);"Yes";"No")


   Change to

=IF(B12=MEDIAN(B12;120;129);"Yes";"No")

The arguments of the MEDIAN function can be in any order; the
median of three different numbers is the one that is between
the two others. The formula above returns "Yes" also when B12
is equal to one or both of the other two numbers.

  Regards,

Anders S.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Median Function Used as "Between"

[Andrew Pitonyak]

The median is found by adding the "middle values" and dividing by two so the 
answer is 124.5. 
B12 contains 121 and 121 is not equal to 124.5. If cell B12 contained 124.5, 
then the answer would be Yes rather than No. 
You could write a macro to determine "between" or just write the comparisons. 
If you have only two values it might look something like this: 

=IF(AND(MIN(120,129) < B12,B12 < MAX(120,129)),"Yes","No")



On Tuesday, August 23, 2022 09:36 EDT, David Stuhr 
 wrote:
 Hello,

Can the Median function in Open Office Spreadsheet be used as a between
function?

When the following equation is entered

=IF(B12=MEDIAN(120;129);"Yes";"No")

and cell B12 contains 121 formatted as Number General the equation
returns No.

I have also tested the equation with the values 120 and 129 replaced by
cell references and the same false value (No) is returned.

I have also replace the value of cell B12 with the value 118 and the
same false value (No) is returned.

All of my research on the web indicates that this equation works in
other spreadsheet products.

I am using Open Office 4.1.13 on a Windows 11 PC.

Am I doing something incorrectly?

David

 

 

Median Function Used as "Between"

[David Stuhr]

Hello,

Can the Median function in Open Office Spreadsheet be used as a between 
function?


When the following equation is entered

=IF(B12=MEDIAN(120;129);"Yes";"No")

and cell B12 contains 121 formatted as Number General the equation 
returns No.


I have also tested the equation with the values 120 and 129 replaced by 
cell references and the same false value (No) is returned.


I have also replace the value of cell B12 with the value 118 and the 
same false value (No) is returned.


All of my research on the web indicates that this equation works in 
other spreadsheet products.


I am using Open Office 4.1.13 on a Windows 11 PC.

Am I doing something incorrectly?

David