-------- Original Message -------- From: Tinkerer <j_taylo...@btinternet.com> To: users@global.libreoffice.org Date: Wed, 13 Mar 2013 04:03:55 -0700 (pdt)
> Using Mac 10.8.2 and Libre 4.0.1, I find that the the IF function does not > place a blank space as the second option. > Have I done something insanely stupid, or is this a bug? > Where I should get blank cells I am getting: #DIV/O! > > ASTest.ods <http://nabble.documentfoundation.org/file/n4043493/ASTest.ods> > > Tests and comments please. > > Tink. Using the formula in G10 as an example: =IF(C10*100/B10>0,C10*100/B10,"") C10 is empty (zero value) B10 is empty (zero value) So zero * 100 / zero = Divide by zero error. One possible alternative (other tests could be added): =IF(B10<>"",(C10*100/B10>0,C10*100/B10,"")) Dave -- For unsubscribe instructions e-mail to: users+h...@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