Formula construction help
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
Re: Formula construction help
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
Re: Formula construction help
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
Re: Formula construction help
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
