Re: Formula construction help
On Saturday, November 4, 2023 at 11:10:28 PM EDT, David Robley wrote: Responses in line: >On 2023-11-05 11:58, Donald Town wrote: >> >> 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. >At the top left of the window in which you are working should appear the filename followed by the application that has opened the file - Calc for spreadsheet or Base for database. Ah! D'oh! I MISSED that staff meeting! Yup, it's there but I never noticed that part! >> Mathematically I could / should have written it as... >> >> If K102 < 14 then L102 = "Yes", else L102 = "No" >I'll continue to assume Calc until proven otherwise. No longer an assumption now! >Note that a spreadsheet formula can only affect the cell in which it is >contained. THIS is why it wasn't working for me. I was trying to do it by "remote control" from elsewhere! >If you want to display the "Yes" or "No" in L102 then the formula must be in >L102 and would be: >=IF(K102 < 14; "Yes"; "No") I made a test file on THIS computer and it worked. Transferred the test file to the OTHER machine and it also worked. Somehow I was making one other minor mistake ... after I had tried it in the correct spot. >> I can set up a simplified version if that helps everything... and if it's ok >> to send it to the list. >The list strips attachments, so that wouldn't be possible. Good thing to know. Kind'a thought that was the case... I've actually been monitoring the list a little for some time now... but hadn't sent anything. MOST times I can figure out most of what is needed. >Alternatively >you could register and post on >https://forum.openoffice.org/en/forum/index.php Hmmm... I did register quite some time ago. Actually sending thie message, I grabbed the address to post straight off someone else's post. My issue HERE may be that I'm using a different computer than the one I registered on. THAT one... is down and not functional... so maybe the mailing software is blocking me from posting directly because I'm not posting from the origin machine that I originally subscribed from... a borrowed computer. > So, that's where things are...and most certainly I do appreciate the input / > feedback / help. > Thanks again for everyone's input and courtesy. ... and Robin, please don't give up on being courteous to people. Your on list courtesy in your attempt is certainly *NON-toxic", & friendly! I appreciate your olive branch! > Don - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Formula construction help
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, 許哲崇 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 於 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 > >
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