Re: [libreoffice-users] Re: =IF Function
Hi :) Lol, i assumed that after we got the "bleeding obvious" out the way we would find something more complex than just a late-night coding issue. Still best to get the "waggle the wires" or "switch it off and then switch it on again" type answer out the way first. Regards from Tom :) > > From: Tinkerer >To: users@global.libreoffice.org >Sent: Tuesday, 18 June 2013, 11:22 >Subject: [libreoffice-users] Re: =IF Function > > >DOH! > >Thanks all. >I gave you a wonderful chance to point out the bleeding obvious. > >I tried putting the quote marks around the text and got an error result. >That was late last night so I must have done something wrong. > >Tink. > > > >-- >View this message in context: >http://nabble.documentfoundation.org/IF-Function-tp4062008p4062031.html >Sent from the Users mailing list archive at Nabble.com. > >-- >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 > > > > -- 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
[libreoffice-users] Re: =IF Function
DOH! Thanks all. I gave you a wonderful chance to point out the bleeding obvious. I tried putting the quote marks around the text and got an error result. That was late last night so I must have done something wrong. Tink. -- View this message in context: http://nabble.documentfoundation.org/IF-Function-tp4062008p4062031.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Re: =IF Function
IF(Test,"OK","") shows OK if Test is True and nothing (the cell is blank) if False Hope this helps ;) -- View this message in context: http://nabble.documentfoundation.org/IF-Function-tp4062008p4062015.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Re: =IF Function
Thank you Brian I'd forgotten that there is a material difference between Empty cells and Blank cells, even though I noticed that the result sometimes varied. Tink. -- View this message in context: http://nabble.documentfoundation.org/IF-Function-tp4043493p4043610.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Re: =IF Function - SOLVED
I could not get your prompts to work, but they gave me ideas. The final formula was: =IFERROR(C30*100/B30,"") This also covered other errors where only one number was present, so no calculation was possible. Many thanks, Tink. -- View this message in context: http://nabble.documentfoundation.org/IF-Function-tp4043493p4043543.html Sent from the Users mailing list archive at Nabble.com. -- 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