Excell

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"

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

Re: Median Function Used as "Between"

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.

Median Function Used as "Between"

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