Multiple Nested IF formula receive Error: Syntax error. Extra ',' I'm trying to write a multiple nested if formula but keep receiving the following error.   Error: Syntax error. Extra ','  IF((TODAY() &gt; CloseDate &amp;&amp; TEXT(StageName)='Donation Likely'),TRUE),    IF((TODAY() &gt; CloseDate &amp;&amp; TEXT(StageName)='Donation Prospecting'),TRUE), IF((TEXT(StageName) &lt;&gt; 'Donation Likely'||TEXT( StageName ) &lt;&gt; 'Donation  Prospecting'|| TODAY() &lt; CloseDate,FALSE)
Formula Error: Syntax error. Extra ',' I am trying to write a formula for opportunities but I keep getting the following error   Error: Syntax error. Extra ','  Here is my formula       IF      (TODAY() &gt; CloseDate &amp;&amp; TEXT(StageName)='Donation Likely')     ||      (TODAY() &gt; CloseDate &amp;&amp; TEXT(StageName)='Donation Prospecting'),"Past                   Due","Expecting")
Let $f:\mathbb{R}\longrightarrow \mathbb{R}$ a differentiable function such that $f'(x)=0$ for all $x\in\mathbb{Q}$ Let $f:\mathbb{R}\longrightarrow \mathbb{R}$ a differentiable function such that $f'(x)=0$ for all $x\in\mathbb{Q}.$ $f$ is a constant function? How do I use F3 to get my coordinates when my laptop makes F3 a special key? Prove that $f(x)\in \mathbb{Z}[x]$ such that $f(0)$ and $f(1)$ are odd has no integer roots How to easily build your own Linux Distro? I wanted to have a go at creating my very own Linux Distribution. Could you suggest some nice and easy-to-follow tutorials (preferably text based and not videos). I have heard something about Arch Linux but I don't know how to go from there. What do I need? How to show subsubsections and paragraphs in TOC? So we have something like:  \documentclass{article} \setcounter{secnumdepth}{2} \setcounter{tocdepth}{2} \usepackage{amsmath}  \begin{document}  \tableofcontents  \section{Brushless Motor Fundamentals} \subsection{Brushless Motor Operation} \subsubsection{DC Motor Operation} Torque is generated in DC motors from the magnetic force, also known as the Lorentz force, which is produced when an electric current is passed through a coil in a magnetic field. This force is given by $F=q[E+(v\times B)]$, where $F$ is the force perpendicular to the coil, $E$ is the electric field in the coil, $B$ is the magnetic field, and $v$ is the velocity of the charged particles in the coil. From mechanics, torque is $\tau=F\times r$.  \section{Brushless Motor Fundamentals 2} \subsection{Brushless Motor Operation} \subsubsection{DC Motor Operation 2} If the electrical force is ignored and the remaining magnetic force is used, with the assumption that $v$ is perpendicular to $B$, we find that $\tau=qvBrsin\theta$.  \end{document}   How to show subsubsections and paragraphs in TOC? I have a quick question. Looking at the next GIF that I made, what is the quickier way you can come up with to delete the excess material that goes beyond the wall? It is basically the attachment of the handrail to the wall what is giving me this "problem".    My solution would be using the boolean modifier with a cube or something, so obviously I know how to do it. But I'm looking for the best solution, i.e., does Blender let me select the excess material in any way? For example, is there a quick way to intersect those planes? I read about intersecting planes in Blender and seems like a difficult task (not worth it in this case). So I discarded that solution.  Thanks. How do the tens­es and as­pects in English cor­re­spond tem­po­ral­ly to one an­oth­er? Non-na­tive speak­ers of­ten get con­fused about what the var­i­ous tens­es  and as­pects mean in English. With in­put from some of the folk here I've put to­geth­er a di­a­gram that I hope will pro­vide some clar­i­ty on the mat­ter.  I of­fer it as the first an­swer to this ques­tion. Con­sid­er it a liv­ing doc­u­ment. In­put is wel­come, and good sug­ges­tions will be  in­cor­po­rat­ed in­to the di­a­gram.    No­ta bene: What this is not is a dis­cus­sion of whether there are  more than two tens­es in English. , to which this ques­tion is not in­tend­ed to sup­ply ar­gu­ments one way or the oth­er.  Here, the aim is to pro­vide an overview of what con­struc­tions English-speak­ing peo­ple use for con­vey­ing in­for­ma­tion about ac­tions re­fer­ring to past, present, and fu­ture, and to pro­vide it first and fore­most to pre­cise­ly the peo­ple who are like­ly to use "tense" as a catch-all term in their search, rather than to lin­guists who know bet­ter.  Break­ing News There is now an ex­cel­lent ELU blog ar­ti­cle ti­tled  . It is high­ly rec­om­mend­ed read­ing. How to force the browser to reload cached CSS and JavaScript files I have noticed that some browsers (in particular, Firefox and ) are very zealous in using cached copies of .css and .js files, even between browser sessions. This leads to a problem when you update one of these files, but the user's browser keeps on using the cached copy. What is the most elegant way of forcing the user's browser to reload the file when it has changed? Ideally, the solution would not force the browser to reload the file on every visit to the page.  I have found  and  suggestion to be useful. It turns out there is a term for this: auto-versioning. I have posted a new answer below which is a combination of my original solution and John's suggestion. Another idea that was suggested by SCdF would be to append a bogus query string to the file. (Some Python code, to automatically use the timestamp as a bogus query string, was .) However, there is some discussion as to whether or not the browser would cache a file with a query string. (Remember, we want the browser to cache the file and use it on future visits. We only want it to fetch the file again when it has changed.) Sometimes (old) comments break the parser, so it would be nice to view their code to check what was (actually) supposed to be there. Is there any way to view a comment's source just like the source link in a post's revision?  edit Another application for this would be the ability to better quote comments in an answer without having to re-markdown them. Fancy chapter headings how can I extrude curve shapes onto curve without tapering I'm stuck. Can't figure out how I can extrude a closed curve onto a NURBS curve without it looking tapered.   I notice that when it's set to "2D" there is no tapering, but I want to do it on 3d.  Thanks for help. How did Gandalf elude and puzzle Sauron? In the History of Middle-Earth book collection Myths Transformed we learn a lot about how Sauron perceived the Istari and what he knew of them.     Sauron had, in fact been very like Saruman, and so understood him quickly and could guess what he would be likely to think and do, even without the aid of the palantiri or of spies; whereas Gandalf eluded and puzzled him.   (Home X: Myths Transformed)     Gandalf he did not understand. But certainly he had already become evil, and therefore stupid, enough to imagine that his different behaviour was due simply to weaker intelligence and lack of firm masterful purpose. He was only rather a cleverer Radagast &mdash; cleverer, because it is more profitable (more productive of power) to become absorbed in the study of people than of animals.   (ibid)  My question now is how does Gandalf elude and puzzle Sauron so much? We know he found Saruman simple to guess down to having similar minds (maybe down to both being maia of Aule?), we also know he must know a fair bit of Radagast as he refers to Gandalf as merely a smarter version of Radagast who was known to have abandoned his task which the Istari were given.   While Sauron went face to face with Saruman via the palantir, it is surprising that he finds Gandalf basically strange, even though Gandalf in reality does the most to circumvent Sauron out of the Istari in the north-west.   Gandalf enters Dol Guldur which Sauron flees. Gandalf enters Dol Guldur again in secret and claims he only just escaped with his life,  which suggests Sauron may have ended up noticing him. Gandalf pushes White Council to attack Dol Guldur which Sauron foresees. Gandalf fought with all nine of Sauron's greatest servants at Weathertop and played a part in destroying their physical bodies temporarily. Gandalf leads the Fellowship from Rivendell, which Sauron also knows. Gandalf strives with the Dark Tower when Frodo puts the ring on at Amon Hen. Gandalf is present at the Battle of the Black Gate, in which the mouth of Sauron declares they know all about Gandalf.   As I've pointed out, Gandalf is clearly sent to contest Sauron. But I don't understand why Sauron does not see this; throughout the Third Age, well, since the coming of the Istari Gandalf has played a role in almost every contest against Sauron.  So how did he elude and puzzle him? Is the ideal $I = \{f\mid f (0) = 0\}$ in the ring $C [0, 1]$ of all continuous real valued functions on $[0, 1]$ a maximal ideal? Is the ideal $I = \{f \mid f (0) = 0\}$ in the ring $C [0, 1]$ of all continuous real valued functions on the interval $[0, 1]$ a maximal ideal? 18.04: color emoji not showing up at all in Chrome, only partially in Firefox How can energy be useful when it is 'abstract'? Dual boot windows 8 and Ubuntu with Windows 8 Boot manager How do I avoid conversation with strangers while traveling? Using QGIS3 Processing algorithms from standalone PyQGIS scripts (outside of GUI) I'm writing a script which must work outside of QGIS GUI. I call some API functions from qgis.core but I'd like to use the processing plugin.  I'm able to import processing with sys.path.append() but I can't run any process. Moreover, all "native" algs are missing in QgsApplication.processingRegistry().algorithms()  So is it possible to run processing that way ? What am I missing ?  import os, sys from qgis.core import * QgsApplication.setPrefixPath('/usr', True) qgs = QgsApplication([], False) qgs.initQgis()  sys.path.append('/usr/share/qgis/python/plugins') from processing.core.Processing import Processing Processing.initialize() import processing  layer1 = QgsVectorLayer('data/ROUTE_PRIMAIRE.SHP') layer2 = QgsVectorLayer('data/ROUTE_SECONDAIRE.SHP')  processing.run('qgis:union', layer1, layer2, 'test.shp') # returns nothing   I'm on QGIS 3.0.1 - Debian 9 During self-study, I ran across the question of how many ways six numbers can be chosen from the numbers 1 - 49 without replacement, stipulating that no two of the numbers be consecutive.  I can obtain a simple lower bound by saying that, in the worst-case scenario, when you choose a particular number, there are now three numbers that cannot be chosen next.  For example, if I first pick 17, then I can't choose 16, 17, or 18 for the remaining choices.  This gives me the lower bound  $$\frac{49*46*43*40*37*34}{6!} = 6,773,770 \frac{8}{9}$$  This is about 48% of ${}_{49}C_6 =  13,983,816$.  The real answer must be bigger (and an integer).  I haven't found a way to calculate it, though.  The original problem asked to show that the probability of having non-consecutive integers when you choose six is greater than 50%, so if the problem is complicated to count exactly, better approximations that show the answer is above 50% would also be appreciated.   Of course, I can use a computer to do the counting, but I'm interested in learning what methods I'm missing. What is so special about $\alpha=-1$ in the integral of $x^\alpha$? Of course, it is easy to see, that the integral (or the antiderivative) of $f(x) = 1/x$ is $\log(|x|)$ and of course for $\alpha\neq - 1$ the antiderivative of $f(x) = x^\alpha$ is $x^{\alpha+1}/(\alpha+1)$.  I was wondering if there is an intuitive (probably geometric) explanation why the case $\alpha=-1$ is so different and why the logarithm appears?  Some answers which I thought of but which are not convincing:   Taking the limit $\alpha=-1$ either from above or below lead to diverging functions. Some speciality of the case $\alpha=-1$ are that both asymptotes are non-integrable. However, the antidrivative is a local thing, and hence, shouldn't care about the behavior at infinity.