On 2023-11-02 18:25, Donald Town wrote:
Hi everyone
I'm working on a database that has a group of basic formulas to get needed
values.
I'd like to configure a "Yes / No' location (set of adjacent cells) to identify
if a value is greater than / less than a boundary.
If > 14 then report "No".
If < or = 10 then report "Yes".
My only issue is not knowing how to construct the formula correctly.
Any help appreciated.
Thanks
Don
Using a couple different versions of OO on 3 different older Macs.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
You haven't said which component of AOO you are working with. You
mention database but then mention adjacent cells, which would suggest Calc.
Assuming the latter, a formula like the following should achieve what
you seem to want. You haven't mentions what to display if value is
between 10 and 14 so I've used UNDEFINED; replace with whatever you
want. Assuming your "value" is in A1, place in B1
=IF( A1 > 14; "NO"; IF( A1 <= 10; "YES" ; "UNDEFINED"))
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
