The IIF function will do what you want easily On Thu, 2 Nov 2023, at 09:57, David Robley wrote: > 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
-- Best Regards Robin --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org