At 14:40 04/02/2015 +0100, Gordom Noname wrote:
I have 2 (or sometimes more) values (numbers) and want to compare
them and check if they are more-less equal. Let say the condition is
fulfilled if the numbers are exactly equal or the difference is not
higher than (+/-) 1.
Here is the example:
3,1 3 TRUE
5,9 6 TRUE
7 -5 FALSE
10 9 TRUE
-6 -6 TRUE
Any clues how I can do this?
For two numbers,
=ABS(A1-B1)<=1
For more than two numbers,
=MAX(A1;B1;C1;...)-MIN(A1;B1;C1;...)<=1
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted