I think it is I have used it in the past, of is aoo different from oo On Thu, 2 Nov 2023, at 21:55, David Robley wrote: > Unfortunately IIF isn't implemented in AOO Calc. > > On 2023-11-02 22:06, Robin Lord wrote: >> 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 > > > > --------------------------------------------------------------------- > 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
