At 21:11 21/06/2015 +0100, Pete Nikolic wrote:
At 19:31 21/06/2015 +0100, Pete Nikolic wrote:
I am running Libre office Version 4.3.7.2 on Arch Linux. I have a
lot of cells with this or similar in
=IF(D10-K10>0,D10-K10,"")
the problem is that if either D10 or K10 is blank the result is
displayed as #VALUE! that means several hundred times not only is
it a pain but it mucks the printing up as well the results do not
look good covered in #VALUE! . What is the trick to preventing the
display of aforementioned string.
I have managed to get round it right now using
=IF(COUNT(D10-K10)=2,D10-K10,"")
That seems to do the job ...
I fancy you mean
=IF(COUNT(D10,K10)=2,D10-K10,"")
- with a comma, not a minus sign.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
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
