By Free Republic | Created at 2024-09-22 04:59:39 | Updated at 2024-09-30 07:24:12
1 week ago
LibreOffice Calc Question (Another Saturday Night Computer Question)
Me | 9/21/2024 | Paul R.
Posted on 09/21/2024 9:52:15 PM PDT by Paul R.
In LibreOffice Calc, if I have two fields I wish to compare to within a plus-minus value, and then if the spread between the two numbers is too great, both will, say, flash red, how do I do that?
TOPICS: Computers/Internet
KEYWORDS: comparison; field; libre; spreadsheet
Click here: to donate by Credit Card
Or here: to donate by PayPal
Or by mail to: Free Republic, LLC - PO Box 9771 - Fresno, CA 93794
Thank you very much and God bless you.
For example, let's say I want to compare B38 and B139, to within a variation of +/- 10 units. If B38 = 1000, and B139 is anything from 991 to 1009, nothing happens. If, however, B38 is 1000 and B139 is, oh, say 889, or maybe it is 1010, then both values blink red.
How do I accomplish this? It seems a basic function, but all I could find on it lead to much more involved making of comparisons than the simple task I have in mind.
1 posted on 09/21/2024 9:52:15 PM PDT by Paul R.
To: Paul R.
2 posted on 09/21/2024 9:52:33 PM PDT by Paul R. (Bin Laden wanted Obama killed so the incompetent VP, Biden, would become President!)
To: Paul R.
Y’all with good background in this can tell, I’m sure no spreadsheet wizard! I basically know just enough to get by with very simple spreadsheets in LibreOffice Calc.
3 posted on 09/21/2024 9:54:13 PM PDT by Paul R. (Bin Laden wanted Obama killed so the incompetent VP, Biden, would become President!)
To: Paul R.
Paul, you do know there is Stack Exchange and many other places that can help you, correct?
4 posted on 09/21/2024 9:56:13 PM PDT by ConservativeMind (Trump: Befuddling Democrats, Republicans, and the Media for the benefit of the US and all mankind.)
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson
