Excel Formula Help Required- Multiple IF Formulas
Categorize my data into 3 groups
How can I make an overset symbol at the same size and height as \bar except with a different symbol? Apologies for the cryptic title, but I was not sure how best to phrase the question in one sentence. I am essentially trying the create a vector symbol with \rightharpoonup as the top instead of the arrow.  The output to the following code will feature an overset harpoon over x, next to a simple \bar{x}. Observe that on the left, the top symbol is significantly higher and bigger than on the right one.  \documentclass{article}  \usepackage{amsmath,amsfonts,amsthm,amssymb}  \newcommand{\vect}[1]{\overset{\rightharpoonup}{#1}}  \begin{document} $$ \vect{x} \quad \bar{x} $$ \end{document}   I would like to create something that looks in every way like the right hand symbol, except using something that looks like \rightharpoonup at the top.  If this command sequence already exists in LaTeX, please use that as an answer, because I have searched for and failed to find it so far. Suspend broken on Ubuntu 16.04 LTS, Dell XPS 9350 Since I upgraded from Ubuntu 15.10 to Ubuntu 16.04 LTS on my Dell XPS 9350, suspend is broken. When closing my lid the laptop will suspend, but resuming fails and it reboots. I tried pm-suspend and tried resuming, resuming failed and the laptop rebooted. I got the following errors when I got back into Ubuntu. The odd thing in my opinion is that it claims the kernel is not an official ubuntu package. Either way my Linux knowledge is not sufficient to know what's going wrong here.      EDIT: I just tried installing kernel 4.4.8 which should fix some things, but it did not fix this problem. By now I also tried 4.4.9 and 4.6 RC7. None of them fixed it for me. How do I make a table row on a web page look draggable? I have a table on a web page where I need to let the user reorder the rows. I was thinking of letting the user drag the rows to reorder them. But how would I let the user know that he could do that? Should I make an empty cell as the first column with dots or vertical lines like gmail has for each email in the inbox? Where can I get an image like that? Do I use a "grabbing hand" icon for the cursor or a "move" cursor? Do I show the cursor while hovering over the table or just the "grab area"? Do I let the user grab any part of the row to drag? How to manually typeset text in parallel on facing pages in (Lua)LaTeX? I want to typeset a bilingual text in parallel on facing pages using LuaLaTeX. The existing solutions to automate this task have proven unsatisfactory as they don't allow for footnotes (parallel), don't allow for different font sizes of the two parallel texts (), or generally provide a poor result of aligned text chunks (eledpar).  As the text is not too long, I really came to consider breaking the pages myself. For this to do, I have to solve the following problem(s):  Consider two facing pages with ending paragraphs of different length. The following paragraphs should then begin at the same vertical position such that the beginnings of these following paragraphs face each other. For this to accomplish on has   to determine the position of the end of the longer paragraph on its page to have the means to let the next parallel paragraphs both begin at the identified position.   Is this something which is doable? Are there mechanisms provided by (Lua)LaTeX to determine positions on a page and to begin typesetting at a specific position on a page?  EDIT: The following example illustrates the task. Here the latin paragraph starting with "O tempora, o mores" (third chunk of text in the code) should begin at the facing position of the beginning of the paragraph "Shame on the age..." (fifth chunk).  \documentclass[a6paper]{scrbook} \usepackage{fontspec} \usepackage[latin,english]{babel} \begin{document} \mbox{}\pagebreak  \noindent\selectlanguage{latin}{\large quo usque tandem abutere, Catilina, patientia nostra? quam diu etiam furor iste tuus nos eludet? quem ad finem sese effrenata iactabit audacia? nihilne te nocturnum praesidium Palati, nihil urbis vigiliae, nihil timor populi, nihil concursus bonorum omnium, nihil hic munitissimus habendi senatus locus, nihil horum ora voltusque moverunt? patere tua consilia non sentis, constrictam iam horum omnium scientia teneri coniurationem tuam non vides? quid proxima, quid superiore nocte egeris, ubi fueris, quos convocaveris, quid consili ceperis quem nostrum ignorare arbitraris?\par\newpage}  \noindent\selectlanguage{english}When, O Catiline, do you mean to cease abusing our patience? How long is that madness of yours still to mock us? When is there to be an end of that unbridled audacity of yours, swaggering about as it does now?  Do not the nightly guards placed on the Palatine Hill — do not the watches posted throughout the city — does not the alarm of the people, and the union of all good men — does not the precaution taken of assembling the senate in this most defensible place — do not the looks and countenances of this venerable body here present, have any effect upon you? Do you not feel that your plans are detected? Do you not see that your conspiracy is already arrested and rendered powerless by the knowledge which every one here possesses of it? What is there that you did last night, what the night before — where is it that you were — who was there that you summoned to meet you — what design was there which was adopted by you, with{\parfillskip0pt\relax\par}  \noindent\selectlanguage{latin}{\large O tempora, o mores!\par\newpage}  \noindent\selectlanguage{english}which you think that any one of us is unacquainted?  Shame on the age and on its principles! \end{document} How to receive sms from our android app? onKeyUp not firing for ESC in IE Could "them" mean "those"? Background Nowadays, I see &quot;them&quot; used to mean &quot;those&quot; a lot. I don't know if it was as common in the past. For example, take &quot;one of &quot;. On researching about it, I found some people say it comes from a dialect of British English. Some others say it is a &quot;non-standard&quot; usage. I see this usage in Canadian English also, and it seems some people use it in a sarcastic way. Moreover, I have seen a song titled &quot;one of them days&quot;. I also read, in the book called &quot;A Broken Promise&quot;, &quot;&quot; Finally, Wikipedia says that it is a usage in  (a common name for the Southern Midland dialect of American English):  Pronouns and demonstratives &quot;Them&quot; is sometimes used in place of &quot;those&quot; as a demonstrative in both nominative and oblique constructions. Examples are &quot;Them are the pants I want&quot; and &quot;Give me some of them crackers.&quot;    Question(s): What would you say about the usage of this word? Is it correct? Could we use it in daily speech? Could this usage go beyond a specific dialect and be used in other dialects, regions, etc.? Does it really originate from Appalachian English? Why did this usage become popular among other English speakers? Note: I have already seen a similar question:  However, it only says, &quot;ungrammatical,&quot; there. This question is specific to this situation only, and there is more to it. How to remove uninstalled wine app icons from unity dash? Can we interchange the sentences " What's the date today?" and "what day is it today?"  In grammar is it correct to use these sentences interchangeably?  For example "What's the day today?" and "what date is it today?" What partitioning scheme do you recommend for a desktop? I've always created three or four primary partitions -- root, swap, home, and sometimes a separate boot partition. Ubuntu's default install offers LVMs. I've never had to add additional drives or space, so it never seemed like a big deal. Whenever I do a fresh install, though, I always think there might be a better way. In IE 9 you can type in whatever number you want to get the perfect zoom but in Chrome all I see is the + and - in the drop menu.  How do I choose a custom zoom and set it as the default? Fermi in his lecture asserts:     The second law of thermodynamics rules out the possibility of constructing a perpetuum mobile of the second kind.   So, this means there can be no machine which just transforms all the heat energy gained by cooling surrounding bodies into mechanical work.  But how does actually the Second Law prohibit this?   The hot reservoir provides heat energy to the system. Does it cause a decrease in entropy of the universe(system + hot reservoir)? How? In order to receive heat wouldn't the system have to be cooler than the reservoir? If so, then entropy increases as the heat energy gets expelled from the reservoir at a higher temperature than the temperature the system receives the heat energy. Is it so?  I'm not getting how the Second Law nullifies the existence of this machine. Could anyone please explain how the Law prohibits the perpetual machine of the second kind? The origin of the value of speed of light in vacuum I just bought a house. Now I'm getting ads in the mail every day or two trying to get me to sign up to pay my mortgage bi-weekly (every two weeks) or weekly instead of monthly. In their words I could cut seven years and thousands of dollars off what I pay in long term. It seems like I would be paying the exact same amount of money, also.  I know "if something sounds too good to be true then probably it is". But I cannot figure out why in this case. What is the catch? Or is this something I should be signing up for ASAP? Good tool for finding photo duplicates based on image data What is a good (and preferably free) tool for finding photo duplicates based on the photos themselves?  So, not filename, filesize etc., but how the photos look like. It would be nice if it managed to match photos that were the same image, but not exactly the same size for example too. Why is gravity such a unique force? My knowledge on this particular field of physics is very sketchy, but I frequently hear of a theoretical "graviton", the quantum of the gravitational field.  So I guess most physicists' assumption is that gravity can be described by a QFT?  But I find this weird, because gravity seems so incredibly different from the other forces (yes, I know "weirdness" isn't any sort of scientific deduction principle).  For relative strengths:   Strong force: $10^{38}$ Electromagnetic force: $10^{36}$ Weak force: $10^{25}$ Gravity: $1$   Not only does gravity have a vastly weaker magnitude, it also has a very strange interaction with everything else.  Consider the Standard Model interactions:    No particle (or field) interacts directly with all other fields.  Heck, gluons only barely interact with the rest of them.  So why is it then that anything that has energy (e.g. everything that exists) also has a gravitational interaction?  Gravity seems unique in that all particles interact through it.  Then there's the whole issue of affecting spacetime.  As far as I'm aware, properties such as charge, spin, color, etc. don't affect spacetime (only the energy related to these properties). Exercise from Atiyah-Macdonald, Chapter 1, 2.iv) Let $A$ be a ring and let $A[x]$ be the ring of polynomials in an indeterminate $x,$ with coefficients in $A.$ Let $f=a_0 + a_1x+\cdots+a_nx^n \in A[x].$ $f$ is said to be primitive if $(a_0,a_1,\ldots,a_n)=(1).$     Prove that if $f,g\in A[x],$ then $f$ and $g$ are primitive $\Rightarrow$ $fg$ is primitive.   I know Gauss lemma holds true for UFDs, but in this case it isn't required $A$ to be UFD: is it possible to drop the assumption, or is some hypothesis missing here? Let $(x_n)_{n\in \mathbb{N}}$ be a sequence of real numbers. A well known result is:     The sequence $(x_n)_{n\in \mathbb{N}}$ converges to $a\in \mathbb{R}$ if and only if every subsequence $(x_{n_k})_{k\in \mathbb{N}}$ converges to $a\in \mathbb{R}$.   Now, I'm working on an exercise which essentialy asks to prove the following:     The sequence $(x_n)_{n\in \mathbb{N}}$ converges to $a\in \mathbb{R}$ if and only if for every subsequence $(x_{n_k})_{k\in \mathbb{N}}$ there is a (sub)subsequence $(x_{n_{k_j}})_{j\in \mathbb{N}}$ which converges to $a$.   Now, one direction is trivial. If in fact $(x_n)_{n\in \mathbb{N}}$ converges to $a$, then by the result I've mentioned, every subsequence of $(x_{n})_{n\in \mathbb{N}}$ converges to $a$. Let then $(x_{n_k})_{k\in \mathbb{N}}$ be an arbitrary subsequence. In that case, we know that it is a subsequence of itself, and hence we've found a (sub)subsequence which converges to $a$.  The other way around seems quite complicated for me. The reason is as follows: I must assume that every subsequence $(x_{n_k})_{k\in \mathbb{N}}$ has a (sub)subsequence which converges to $a$ and the proof that the original one converges to $a$.  My problem is exactly that "a". If it had all (sub)subsequences converging to $a$, then by the result i've mentionted, the subsequence $(x_{n_k})_{k\in \mathbb{N}}$ would converge to $a$. In that case, we would have every subsequence converging to $a$ and the result would follow.  My idea to prove the claim was then:  First remember that a subsequence is the restriction of the original one $x: \mathbb{N}\to \mathbb{R}$ to an infinite subset $\mathbb{N}'\subset \mathbb{N}$. In that case a (sub)subsequence is the restriction of $\tilde{x} = x|\mathbb{N}'$ to an infinite subset $\mathbb{N}''\subset \mathbb{N}$. But since $\tilde{x}$ is the restriction of $x$ to $\mathbb{N}'$ and since $\mathbb{N}''\subset \mathbb{N}'$, the restriction of $\tilde{x}$ to $\mathbb{N}''$ is itself the restriction of $x$ to $\mathbb{N}''$.  In other words, every (sub)subsequence can be viewed as a subsequence of the original one. Considering this, by hypothesis every subsequence has a (sub)subsequence which converges to $a$. But by this argument, this means that we can replace every subsequence with a convergent one. And then we can use the result I stated.  Is my idea correct? Is this really the way to prove the claim? My only doubt is that I need every subsequence converging to $a$ to use the result. In this case I can't see how I can argue that this implies every subsequence converges to $a$.  How can I finish this proof? How to remotely display my Android on my PC? There is a thing which is called miracast, it can mirror the display of the Android phone to another monitor, but my screen doesn't have this function, am I possible to do it in Ubuntu? Why is area of a surface of revolution integral $2\pi y~ds$? not '$dx$'?