Re: Formula construction help

2023-11-02 Thread David Robley
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 form

Re: Formula construction help

2023-11-02 Thread Robin Lord
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 (s

Re: Formula construction help

2023-11-02 Thread David Robley
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". I

Formula construction help

2023-11-02 Thread Donald Town
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 is