Re: [libreoffice-users] [Calc] how to compare not exactly equal values?

2015-02-04 Thread Andrew Pitonyak
Subtract the numbers and check the absolute value On Feb 4, 2015 8:40 AM, gordom gord...@wp.pl wrote: Hallo everyone. I do realize my post title is not very descriptive. Sorry for that. I have 2 (or sometimes more) values (numbers) and want to compare them and check if they are more-less

[libreoffice-users] [Calc] how to compare not exactly equal values?

2015-02-04 Thread gordom
Hallo everyone. I do realize my post title is not very descriptive. Sorry for that. 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

Re: [libreoffice-users] [Calc] how to compare not exactly equal values?

2015-02-04 Thread Brian Barker
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:

Re: [libreoffice-users] [Calc] how to compare not exactly equal values?

2015-02-04 Thread gordom
W dniu 2015-02-04 o 14:46, Andrew Pitonyak pisze: Subtract the numbers and check the absolute value Thanks for this, gordom -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines

Re: [libreoffice-users] [Calc] how to compare not exactly equal values?

2015-02-04 Thread gordom
W dniu 2015-02-04 o 15:24, Brian Barker pisze: 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