I want an image to be my hyperlink in Google sheets.  Here is my formula:  =HYPERLINK("google.com/de", IMAGE("http://s5.favim.com/orig/69/hi-love-quote-start-Favim.com-658946.jpg"))   The image shows up on the sheet - but it is no longer a hyperlink.
I need a cell that contains an image to also contain a hyperlink.  Following formula is the only one I found but doesn't work (error analyzing formula)  =HYPERLINK("URL", image("URL"))   Following formula I tried shows a blank cell but the link works  =hyperlink("URL"; Image("URL"))
How to wait in bash for several subprocesses to finish and return exit code !=0 when any subprocess ends with code !=0? Permutation count of AABBC Given a string:  $AABBC=A^2B^2C^1$   I am trying to find the Total Permutations (this may be incorrect):  $\dfrac{5!}{2!\cdot2!}=30$  My question is how would I find the partial sums (perhaps the wrong choice in words) when added together would give an index such that:   $AABBC=1$ $ABABC=2$ $CBABA=29$ $CBBAA=30$   (30 might be the wrong number here but is suppose to be the last)   I have tried to draw out a tree structure to get an idea and thought with as the minimum:  $CAABB$  $4(\dfrac{4!}{2!\cdot2!})$ + 1  And:  $CABAB$  I would get something like:  $4(\dfrac{4!}{2!\cdot2!}) + 0 + 1(\dfrac{2!}{2!}) + 0 + 0$  But I am missing something here. How would I find the sums needed for $BACAB$ ?  More specifically I am trying to find the index of a word that is arbitrarily long in alphanumeric.  So the string may also be something like:  $AAAAABBBBDDEEFFFGGGGGHIIIIJJJJKLMOOOPZZZZZ$ On what systems is //foo/bar different from /foo/bar? Throughout the POSIX specification, there's provision (, , ...) to allow implementations to treat a path starting with two / specially.  A POSIX application (an application written to the POSIX specification to be portable to all POSIX compliant systems) cannot assume that //foo/bar is the same as /foo/bar (though they can assume that ///foo/bar is the same as /foo/bar).  Now what are those POSIX systems (historical and still maintained) that treat //foo specially? I believed (I've now ) that POSIX provision was pushed by Microsoft for their Unix variant (XENIX) and possibly Windows POSIX layer (can anyone confirm that?).  It is used by Cygwin which also is a POSIX-like layer for Microsoft Windows. Are there any non-Microsoft Windows systems? OpenVMS?  On systems where //foo/bar is special, what is it used for? //host/path for network file systems access? Virtual file systems?  Do some applications running on Unix-likes —if not the system's API— treat //foo/bar paths specially (in contexts where they otherwise treat /foo/bar as the path on the filesystem)?    Edit, I've since  about the origin of //foo/bar handling in the spec, and the discussion is an interesting read (from an archaeology point of view at least). How to solve differential equations of the form $f'(x) = f(x + a)$ What could one do to find analytic solutions for $f'(x) = f(x + a)$ for various values of $a$?  I know that $c_1\sin(x + c_2)$ is solution when $a = \frac{1}{2}\pi$, and of course $c_1e^x$ when $a = 0$.  For instance, is there a function satisfying $f'(x) = f(x + 1)$?  What about negative or imaginary $a$?  Is there possibly a generalization? Why are we using the squared residuals instead of the absolute residuals in OLS estimation?  My idea was that we use the square of the error values, so that residuals below the fitted line (which are then negative), would still have to be able to be added up to the positive errors. Otherwise, we could have an error of 0 simply because a huge positive error could cancel with a huge negative error.  So why do we square it, instead of just taking the absolute value? Is that because of the extra penalty for higher errors (instead of 2 being 2 times the error of 1, it is 4 times the error of 1 when we square it). Err 80 appears when I turn on my Canon EOS 5D Mark II How do I kill the lockscreen after the Windows 10 anniversary update? Where can I find examples of good Mathematica programming practice? A friend of mine accidentally left a carton of eggs on her counter, unrefrigerated, for three days. The eggs had been previously refrigerated both at the store and at home. Now she's planning to do some more cooking which requires eggs, and is wondering if it's still safe to use them for baking. I believe she is planning on baking cookies with them, so they would be baked at fairly high temperatures for probably at least 10 minutes. Would this be safe, or are eggs left unrefrigerated for that long not safe for consumption? How does a fork bomb work? WARNING DO NOT ATTEMPT TO RUN THIS ON A PRODUCTION MACHINE   In reading the  I generally follow what's going on with the following code:  :(){ :|:&amp; };:   excerpt of description     The following fork bomb was presented as art in 2002;   its exact origin is unknown, but it existed on Usenet prior to 2002.   The bomb is executed by pasting the following 13 characters into a    shell such as  or . It operates by defining   a function called ':', which calls itself twice, once in the   foreground and once in the background.   However the last bit isn't entirely clear to me. I see the function definition:  :(){ ... }   But what else is going on?  Also do other shells such as ksh, csh, and tcsh also suffer the same fate of being able to construct something similar? Show that for any $k$-cycle $(a_1 a_2...a_k) \in S_n$, and for any permutation $\pi \in S_n$, $\pi(a_1...a_k)\pi^{-1}=(\pi(a_1)..\pi(a_k))$ I was reading the Math.random() javadoc and saw that random is only psuedorandom.    Is there a library (specifically java) that generates random numbers according to random variables like environmental temperature, CPU temperature/voltage, or anything like that? I have a very big file 4GB and when I try to read it my computer hangs. So I want to read it piece by piece and after processing each piece store the processed piece into another file and read next piece.  Is there any method to yield these pieces ?  I would love to have a lazy method. Solving an ODE in power series How do I run 32-bit programs on a 64-bit Debian/Ubuntu? I have a 64-bit (amd64 a.k.a. x86_64) Debian or Ubuntu installation. I need to run 32-bit (i386/i686) programs occasionally, or to compile programs for a 32-bit system. How can I do this with a minimum of fuss?  Bonus: what if I want to run or test with an older or newer release of the distribution? How do I check if a string is a number (float)? What is the best possible way to check if a string can be represented as a number in Python?   The function I currently have right now is:  def is_number(s):     try:         float(s)         return True     except ValueError:         return False   Which, not only is ugly and slow, seems clunky. However I haven't found a better method because calling float in the main function is even worse. Will a bullet dropped and a bullet fired from a gun horizontally REALLY hit the ground at the same time when air drag is taken into account? Using JQuery and Prototype in the same page Several of my pages use both JQuery and Protoype. Since I upgraded to version 1.3 of JQuery this appears to be causing problems, because both libraries define a function named '$'.  JQuery provides a function noConflict() which relinquishes control of $ to other libraries that may be using it. So it seems like I need to go through all my pages that look like this:  &lt;head&gt;           &lt;script type="text/javascript" src="/obp/js/prototype.js"&gt;&lt;/script&gt;     &lt;script type="text/javascript" src="/obp/js/jquery.js"&gt;&lt;/script&gt; &lt;/head&gt;   and change them to look like this:  &lt;head&gt;           &lt;script type="text/javascript" src="/obp/js/prototype.js"&gt;&lt;/script&gt;     &lt;script type="text/javascript" src="/obp/js/jquery.js"&gt;&lt;/script&gt;     &lt;script type="text/javascript"&gt;         jQuery.noConflict();         var $j = jQuery;     &lt;/script&gt; &lt;/head&gt;   I should then be able to use '$' for Prototype and '$j' (or 'jQuery') for JQuery. I'm not entirely happy about duplicating these 2 lines of code in every relevant page, and expect that at some point somebody is likely to forget to add them to a new page. I'd prefer to be able to do the following    Create a file jquery-noconflict.js which "includes" jquery.js and the 2 lines of code shown above Import jquery-noconflict.js (instead of jquery.js) in all my JSP/HTML pages   However, I'm not sure if it's possible to include one JS file in another, in the manner I've described? Of course an alternate solution is simply to add the 2 lines of code above to jquery.js directly, but if I do that I'll need to remember to do it every time I upgrade JQuery. Is it possible to delete the "useless" apps pre-installed on my Mac? Which preposition should follow "guide" here, "on," "to," or "for"? The following link includes a guide ___________ how to use it.  How should I fill in the blank, on, for, or about?