I have 3 cells, VALUE, DOWNPAYMENT, DOWNPAYMENT %.  The 3rd cell "DOWNPAYMENT %" calculates the percentage of "DOWNPAYMENT" over "VALUE"  Is there a way for the user to have the function to input a number in "DOWNPAYMENT %" cell and get a figure in "DOWNPAYMENT".   What I mean is that if both cells could be used at the same time for input of data and for output of calculation.
122836
I'm making a worksheet where the wind speed defines the potential energy of the location. This value is the basis of a few sheets in the same Excel file. I'm trying to write a code that where I10 is the wind speed and I12 is the potential kWh on that location. I want both I10 as I12 to be input cells where you can either say: I want to know what wind speed I need to generate 4000 kwh i.e. or my wind speed is 4.2 m/s what will my potential energy be?  This is what I made so far, but I don't get the power function to work. At the moment I defined the cell I12 (The kWh's) without VBA as =(2208,5/(54,872))*I10^3 where I10 is the windspeed.  VBA code behind sheet which doesn't work:  Private Sub Worksheet_Change(ByVal Target As Excel.Range)     If Target.Address = "$I$10" Or Target.Address = "$I$12" Then          WIND = Range("I10")         KWH = Range("I12")          Application.EnableEvents = False          If Target.Address = "$I$10" Then             Range("I12").Value = (2208.5 / (54.872)) POWER(WIND,3)         Else             Range("I10").Value = POWER( KWH (2208.5 / (54.872)),(1/3)          End If     End If     Application.EnableEvents = True End Sub   Potential solution, but not working at the moment.  Function MyPower(Number As Double, Exponent As Double) As Double     MyPower = Number ^ Exponent End Function
85017
I have a cell in Excel, to which I want to pull data from another cell that is defined as a value in a third cell.  For example:  A1=5 A2=10 A3=insert syntax here, using A4 as source for cell reference A4=user-input selection  When A4 is set to "A1", then A3 should return 5.  When A4 is set to "A2", A3 should return 10.  The above is actually a bit of an over-simplification.  What I'm really looking to do, is to use one cell to define which sheet to pull data from for calculations that will be performed in another cell.  Scenario:  A workbook contains several sheets (Sheet1, Sheet2, Sheet3, etc.) which are laid out identically - a value in 'Sheet1'!A2 represents the same sort of information as is represented by the value in 'Sheet2'!A2.  I want to build another sheet, named Comparison, that allows me to easily compare data between two chosen sheets.  This sheet will also be laid out identically to the others, but the values here should be calculations of the difference between the similar values in the target sheets.  This sheet will also have two special cells which are configured with data validation and in-cell drop-downs, to allow selection of two other sheets, by name, for comparison.  Let's say the selection cells are in A5 and A6.  Given:  A5=Sheet5 A6=Sheet3  Then the formula in 'Comparison!'A2 should result in the same as 'Sheet5'!A2-'Sheet3'!A2.  If I change A6 to "Sheet7", then the formula should adjust to 'Sheet5'!A2-'Sheet7'A2.  Is this sort of dynamic cell referencing easily doable (without a crap-ton of IF statements) in Excel?
32670
Here is a simple table.  I want to merge 4 cells. I want to combine the three "this" cells area in this table. I thought I have to use multirow and multicolum at same time. However, I could not find how to use it.  If possible, could you post the modified LaTeX source code?     My LaTeX code:  \documentclass{article} \usepackage{multirow}% http://ctan.org/pkg/multirow \usepackage{hhline}% http://ctan.org/pkg/hhline \begin{document}  \begin{table}[ph] \begin{center} \begin{tabular}{c|c|c|c|c} \hline \multirow{2}{*}{Raaa (k)} &amp; \multicolumn{4}{c}{C ()} \\ \hhline{~----}  &amp; 3.3 &amp; 2.5 &amp; 1 &amp; 0.5 \\ \hline \multirow{2}{*}{Raaa (k)} &amp; \multirow{2}{*}{this} &amp; this &amp; 0.5 &amp; 0.6\\ \hhline{~~~--}            &amp;                       &amp; this &amp; 0.7 &amp; 1.2 \\ \hline \end{tabular} \caption{R, C ripple size} \label{T:peak} \end{center} \end{table} \end{document}
972
Is it possible to reference a cell in Google Sheets so that cell where it gets displayed also displays it using the same text and cell colour formatting?  =A1   Will only reference cell's value. But if that particular cell has red background and white text I'd like that to be copied as well.  I'm leaning toward existing formula solutions rather than scripts. If applicable of course.
108733
I have a table that looks like this:  RECIPE     VERSION_ID     INGREDIENT    PERCENTAGE 4000       100            Ing_1          23,0 4000       100            Ing_100         0,1 4000       200            Ing_1          20,0 4000       200            Ing_100         0,7 4000       300            Ing_1          22,3 4000       300            Ing_100         0,9 4001       900            Ing_1           8,3 4001       900            Ing_100        72,4 4001       901            Ing_1           9,3 4001       901            Ing_100        70,5 5012       871            Ing_1          45,1 5012       871            Ing_100         0,9 5012       877            Ing_1          47,2 5012       877            Ing_100         0,8 5012       879            Ing_1          46,6 5012       879            Ing_100         0,9 5012       880            Ing_1          43,6 5012       880            Ing_100         1,2   There are 100 ingredients per recipe/version. I'd like to display the data from this table like this:  RECIPE     INGREDIENT_Vxxx     PERCENTAGE_Vxxx     INGREDIENT_Vyyy     INGREDIENT_Vyyy (ETC) 4000       Ing_1               23,0                Ing_1               20,0 4000       Ing_100             0,1                 Ing_100              0,7   Because in different versions of recipes, ingredients could be removed or added, I'd like to display both ingredient and percentage per version per recipe. There's also the difficulty that different recipes have different number of versions.  I'm not even sure if this is possible at all or where to begin. Maybe with the PIVOT function?  Could anyone please point me in the right direction?
101435
I have ran into really funny trouble trying to use \overset and \mathbb the same time. I need to do something like this:    but with the T as mathbb, i.e. \mathbb{\overset{m}T}_{ij}. When I try it, this happens:     Why? How can I make it work?   Note: Putting \overset before the mathbb doesn't work.
99595
if 100 x 1.17 (17%) = 117, how can I know how many % I have to deduct 117 to get 100? Obviously, this is no more 17%.   The same can be applied if 100 - 10% = 90. Then how many % I have to add to 90 to get 100? Again, it is no more 10%.   I know how to calculate this, but I was wondering if there is a math formula for this? something as simple as a*b=c =&gt; b=c/a
15111
This is more a curiosity question than a fix to a problem, because I found a few ways to fix it already.  From what I could gather, if I want to apply a conditional formatting based on the value of another cell, I have to use a custom formula. However, in the list, there are a couple options that would seem to be much more relevant: "Greater than (or equal to)", "Lesser than (or equal to)", "Is (not) equal to", "Is (not) between". But I'm starting to think that they are not so useful.  Here I have a column of numbers ranging from 10 to 30; I want to highlight them in green if they're greater than or equal to a number (20) set in another cell. From a few other questions here and on SO, it would seem that I should use a custom formula as something like =K7&gt;=K4, but instead I still wanted to try the options in the list that seemed more intuitive.    As you can see though, it does some weird things, where it consider 11 to be under 20 (which is true AFAIK), but everything else above 11 is either equal or greater than 20.  My guess is that putting =K4 in the "Value or formula" field didn't quite link to the actual K4 cell, but I can't figure out why it does what it does here.  If I put "20" in the field, it highlights the right cells (but it's not dynamic anymore).  Edit: putting =K$4 works like a charm. Quite literally, in this case.
60552
I have an Excel 2010 workbook that contains a number of individual worksheets. The cells on one of the sheets are linked to individual cells on two other worksheets in the same workbook.  I'm using a direct cell reference that essentially says that whatever value is entered into a particular cell on one sheet also populates cells on two other sheets.  I used the (=) function with the cell reference to accomplish this.  The issue I'm running into is that, even when the primary cell is left blank, the cells that populate from that primary cell will display 0, rather than remaining blank themselves.  I want the subordinate cells to remain blank if the primary cell they're linked to is blank.
30460
I know that it's possible in Excel to toggle between . I'm required to turn in assignments for a statistics class as a printed Excel sheet showing both the formula and the result. Right now the instructor makes us either copy the formula and paste it as text next to the computed value, or copy the value and paste it next to the formula. This is very inefficient, prone to error (if you change the formula or values after doing the copy-paste), and generally a waste of time.  Is there any way to have Excel show the formula and its value in the same cell? If not, is there any function which will display the formula from a referenced cell as plain text, e.g. =showformula(A1) which would print out =sum(A2:A5)  instead of 25 (if those were the formula and value of cell A1)?  I'm using Excel 2010, but a general answer that works for any recent edition of Excel would be nice.
31113
I was wondering if there is a way to have LaTeX interpret $\frac{a}{b}$ as $a/b$, but \[\frac{a}{b}\] as \[\frac{a}{b}\].   It is a little tedious to change a inline equation $a/b$ to a display equation \[\frac{a}{b}\] when doing changes to my text.
32654
I have the following scales:   1 (Strongly Disagree); 2 (Disagree); 3 (Not Applicable); 4 (Agree); 5 (Strongly Agree);     Questionnaire responses:   Question Item1: 2; Question Item2: 3; Question Item3: 1; Question Item4: 1; Question Item5: 4;   If I need to average the above responses into the Excel Sheet, while treating Question Item2: zero (since it is considered missing data), do I need to divide by 5 or 4 items to obtain the average?  $$\text{Average} = \frac{2 + \mathbf 0 + 1 + 1+ 4}{5}\quad\text{or}\quad\text{Average} = \frac{2 + \mathbf{\_} + 1 + 1+ 4}{4}$$  Kindly advise.
47902
How do I calculate the number of options for $k$ different balls in $n$ cells, with at least $1$ ball in each cell?   Lets say $6$ different balls in $3$ different cells, with at least $1$ ball in each cell.   like this:  $$x_1+x_2+x_3 = 6$$  I would like to see an explanation please and not just the answer.  Thanks!
49083
I'm trying to add only "odd" numbers from a range(named "data") which contains numbers, blank cells and text. No matter what I try I always seem to end up with a #value error. My latest attempt is as follows:  =SUMPRODUCT(N(MOD(Data,2)=1),Data) Any suggestions?
50302
I have this table, but wanted to format the first row. I like to match the two columns of first row, and last two columns of the same first row. Any suggestion on how to do that?  \begin{table}[!h]  \caption{Comparison of percentages.} \begin{tabular}{lclclclclc} \hline \hline  Mode &amp;  Var  &amp;  Cum\\ \hline {}       &amp; EF   &amp; CHF    &amp; EF2   &amp; CHF2\\ 1   &amp;  17.5 &amp; 19.1   &amp; 17.5  &amp; 19.1\\ 2   &amp;  11.8 &amp; 12.7   &amp; 29.3  &amp;  31.9\\ 3   &amp;  6.6  &amp;  5.6         &amp; 35.9    &amp;  37.4\\ \hline \end{tabular} \end{table}
89135
I'm trying to convert a percentage: The original percentage represents how bad the condition of a asset is (in other words, a high number is bad). I would like to convert the percentage to represent how good the condition of an asset is (in other words, a high number is good). To do this, I can simply subtract the original percentage from 1 to get the desired percentage. Example:  1 - 0.25 = 0.75  My question is: What is this called in mathematics? As far as I can tell, this is not the same thing as .
34031
Feel silly asking this question, but I need some help!   I want to count how many * appear in a range of 5 cells.  The cells will range from 0-7 * each.   I was thinking of using the =COUNTIF(A2:A:6,"*") function, but if the cell has more than one *, it doesn't work. Any idea what function I should use or how I can modify my COUNTIF function to make it work?  Thanks in advance.