First, thanks to ALL of you for your responses & courtesy.
Second, I don't know how to tell / determine what kind of document it is...
between database or ... "Calc'... whatever distinguishes.
Third, from the Get Info box... on one ( Macbook ) computer, I'm using ...
Version: OpenOffice 4.1.8 AOO418m3 (Build:9803)
...and on a different computer ( a more often used iMac)
Version: 3.1.1 (Build: 9420)
The formula I should have used works logically elsewhere outside OO, but not in
the OO document.
When asking originally, I errored using the above as a two part formula... that
actually contained a problem in the first place.
Apologies for the mistaken way I described my predicament originally.
Mathematically I could / should have written it as...
If K102 < 14 then L102 = "Yes", else L102 = "No"
... but I most certainly still do not understand how to make that work right in
my document.
I can set up a simplified version if that helps everything... and if it's ok to
send it to the list.
So, that's where things are...and most certainly I do appreciate the input /
feedback / help.
Thanks again for everyone's input and courtesy.
Don
On Saturday, November 4, 2023 at 08:00:25 PM EDT, 許哲崇 <fide...@gmail.com>
wrote:
We may have common interest.
So, please keep me informed.
I am learning LaTex and equations in word. You may want to review my
Facebook 許哲崇 (Fideric Hsu)
Donald Town <bg...@sbcglobal.net> 於 2023年11月2日 週四 下午3:55 寫道：
> 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
>
>
