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
