Multiply And Round In One Equation
Mar 1, 2007I need to take a number, multiply it by a precentage, & then round it to the nearest multiple of 5.
ex:
A1=142.5
B2=A1*50%,(then rounded to nearest multiple of 5)
ADVERTISEMENT
Multiply & Round Formula
Mar 21, 2008I am having a calculating issue with a formula I'm trying to use.
What I am trying to do is to multiply the " sum of one cell" with "another cell" for a total.
The following are the cells and data involved.
A12 = 93 C12 = $44.76
A19 = 93 C19 = =sum(C12*0.05) D19 = =sum(A19*C19)
The formulas looked pretty straight forward. My problem is the total I got in D19 was not what I calculated on a calculator. C19 is $2.24 and the above formula gave D19's total as $208.13 but the calculator's total is $208.32.
I can't figure out what is causing the different totals. If there is another formula I should use for this.
Multiply By Percentage And Round Up By Minimum Of 2 Digits If Less Than 2
Jul 9, 2014I have a spreadsheet where I need to multiply each field in a column by 1.015. However, I need each field to roundup by 2 if the mulitplication is less than 2. For an example, a field of 60 would only increase by .9 to 60.9 when mutliplied by 1.015, but I'd like it to display 62. I have attached the spreadsheet for review.
View 4 Replies View RelatedMultiply Number By 3% And Round To Nearest Dime
Feb 2, 2012I am doing a huge price increase for a price book and need to rasie each price by 3% and have it rounded to the nearest dime.
Is there a formula to do this in one go and not have one cell with the rounded price and another for the nearest dime price.
Multiply A Number By Percentages And Round So That They Add Upto The Total %
Mar 14, 2009I want to multiply a number say, 1551 by 5%, 6%, 7%, 8% and 9% and round each result to 0 decimal places. Then the sum of these results (544)should be equal to 35% of 1551 rounded to 0 decimal places (543). How do I create an if function for rounding so that the sum equals 543.
View 6 Replies View RelatedExcel 2000 - If A1 Equal Or Less Than 1000 Multiply By B1 Otherwise Multiply By C1
Oct 30, 2013Excel (2000), what formula would I use to accomplish the following?
If A1 equal or less than 1000 value, multiply by B1, otherwise multiply by C1.
Equation Behind The Function
May 9, 2006How do I get to see the equation behind Excel Functions? For instance, the
result of pmt() is not making sense to me, I'd like to see what this function
is doing and how it is calculating its value. Trial and Error is rather
time-consuming and tedious.
Setting Up A Log Equation
Oct 9, 2009It looks like this (log(X/Y))/log2. The X and Y are celldirections (E2 or F4 and so on). How do i setup that formula in excell?
View 2 Replies View Related1 Equation For 4 Variables
Jul 24, 2012Can I use excel to get make an equation for 4 variables (x,y,z,w)
E.g.
a,b,c,d,3,f,g,h,i, would be constants
w = ax + by + cz + dx^2 + ey^2 + fz^2 + gxy + hyz + iyz
I tried regression but the equation looks like
w = ax + by + cz + c
Is it possible on ay other software e.g MATLAB
SUM IF- Excluded From The Equation
Oct 18, 2007I have the following formula.
=SUMIF(hfx!A:A,"123456789",hfx!J:J)
very simple.
for the totals in J, if there is a (-) negative number, i would like that excluided from the equation.
Using Another Cell's Value In Equation
Oct 22, 2008Lets say I write an equation on my sheet such as:
='A1'!$H422*AH$138
but instead of hard coding the A1 sheet name, I want that to be a value that I can put in a different cell (lets say cell C1) on my same sheet in such a way that it will reference the value in my other cell (Cell C1) and put its value into that equation.
So if I make the value in C1 = A99 then the equation becomes
='A99'!$H422*AH$138
Vba To Get Best Fit Equation Into Cells
Mar 20, 2007i am plotting graphs which i need the equation of the line from. i have been manually typing the x^3, X^2, X^1 and X^0 values into 4 cells which is then used elsewhere, but wanted to know if its possible to get some code to do that for me?
View 2 Replies View RelatedRegress Nonlinear Equation
Nov 20, 2008Below is a nonlinear model, together with calibration data for which I would like to find the parameters Ro, Kc, a and b.
R = Ro + Kc * (1/(1 + exp(-(a + b*lnC))
Calibration Data
C R
0.00.3347
4.80.4201
7.70.5141
11.20.6177
14.40.6887
Given the calibration data above, how can I calculate or at least estimate these parameters?
I do not want to use an add-in program, like Solver, in Excel. I do, however, want to be able to use any existing functions, if necessary, in Excel. i'd appreciate it if someone can walk me through the steps.
Removing Sections Of Equation If Any Value = 0
Jan 13, 2009The equation is basically: 10^[A/20]+10^[B/20]+10^[C/20]. Now imagine that there is no input value for C. I need to make it so that it won't add the bit I've highlighted in green.
View 5 Replies View RelatedGet The Result Of An Equation In A Cell
May 13, 2009I will like to ask, if there is a way to get in a cell the result of a simple equation without having to copy the contents of that cell with a = in front for example if i have in one cell
15*2+35*4+30/2
in the next cell to display the result
185
How To Substitute Cell Value Into Equation
Aug 6, 2012if i obtain an eqn by plotting a graph in excel, etc,
y = 1.22952117E-06x3 - 1.08197863E-05x2 + 9.97531712E-01x + 3.99014495E-01
and i wish to subsitube a cell value from another sheet into the 'x' in the above eqn and i need to do this 20 times.
Move Value To Another Field (with Equation)?
Mar 18, 2013I need to move a value to another field (with equation) and use the output for the same equation till limit is reached..
View 2 Replies View RelatedHow To Add Equation To Dropdown Selection
Jan 11, 2014How to add an equation to a drop down selection if you take a look at the picture in the link supplied, what I want to do is: I want the calculator to take the number in D12 then if the drop down box under it the selection is (as it is) too high then subtract 50 (k11) from D12 and display the answer in D14. I have listed the 3 drop down choices in column L, Lap 2 I would do exactly the same and so on [URL] .........
View 6 Replies View RelatedReferencing The Value In A Cell For A Max Equation
May 20, 2007I have a cell on ' Sheet 2' with the following formula:
=MAX('Sheet1'!C3:'Sheet1'C10)
ie. it chooses the maximum value from column C between rows 3 and 10 on "Sheet 1".
Lets say the cell reference C10 is now entered into cell B1 on Sheet 2. How do I modify the above formula to reference B1?
I have tried INDIRECT function but can't get it to work.
Calculate Best Fit Equation Of Curve
May 16, 2008I am trying to calculate the equation of a curve which best fits some data. On the x-axis is date and y-axis the readings. The curve is quadratic, so on the chart I am fitting a 2nd order polyomial and displaying the equation. To prove that the equation the trendline gives me is reasonable, I am applying the equation on the x parameter to get the y parameter estimate and looking to see the error between predicted and actual - see attached.
The equation and the output from it are clearly rubbish, even though on the graph the trendline is a reasonable fit - see attached. Has anyone any ideas why? I think it has something to do with using a date on the x-axis but no idea why. Is there a way to correct for this? I also tried using the following I to calculate the coefficients which came up with a reasonable forecast (although linest should only be used for linear data): =LINEST(C3:C15,B3:B15^{1,2,3})
Equation To Find Top 2 Highest Values?
Mar 8, 2014I have the following 2 formulas that determine the top 2 scores and return the respective headers, but they aren't perfect.
=INDEX(T1:V2,1,MATCH(MAX(T2:V2),T2:V2,0))
The above returns the max, however doesn't take into account scores that are a tie or 0 values
=INDEX(T1:V2,1,MATCH(LARGE(T2:V2,2),T2:V2,0))
The above returns the 2nd highest value, but some instances the output is correct (if there is a tie or a 0).
How can I fix both of these equations and also determine the 3rd highest score?
Result Of Text Equation In Cell
Sep 14, 2007I have two cells (c1 and c2).
c1 contains (2+3*4)*3 without "=" at start.
c2 must contain the result of c1 it means 42.
In the attached file I have a few variants I tried to solve it but they both don't fit.
Formula.xls
Create A Polynomial Equation Of Z From The X And Y Inputs?
Jan 20, 2014I'm familiar with 2d graphs, trendlines, and regression equations. Now I have some tabular data that has 2 input variables and a result. As with my 2d data, I would like Excel to create a polynomial equation of z from the x and y inputs. Can Excel do this, or do I need a plug-in or another software package?
View 12 Replies View RelatedSumif Equation Summing If Contains Certain Word Plus Others?
Aug 18, 2014Is there a way to use =sumif to sum if the cell has the word you are searching for plus other words you haven't identified.
For instance if I have =sumif(a1:a3,"vacant",a:a) , is there a way I can sum if the cell has "Vacant until next week" without me typing the next week"
I have attached a sample spreadsheet.
Inserting Equation Into X Axis Label
Mar 27, 2014I want to show units on x-axis as 10^10 but it will not let me insert equation. How can I do this? I am using the most recent version of excel.
View 1 Replies View RelatedGetting Equation To Apply To Cells Only With Info In
Jul 30, 2014Any way I can get an equation to only apply to cells with information in? E.g. I have two columns, one with 'disposal dates' in and the other with 'extended disposal dates'. I would like to get the difference between them (Extended disposal dates- disposal dates) however not all of them have an extended disposal date, therefore some cells display as '#VALUE!' because its calculating the disposal date-blank cell....
View 3 Replies View RelatedComboBox: Equation In A Column Of Cells
Nov 12, 2008I want to do is a simple list, 2 items, call them "Thing_1" and "Thing_2". I have an equation in a column of cells. The equation is a simple If statement. If the user selects "Thing_1" then the first equation will run, and if "Thing_2" is selected then the second equation will be used. That's it. No more complex than that.
My original questions about how to initialize a ComboBox are cross-posted here: http://www.excelforum.com/excel-prog...ml#post1996135
How To Use Dropdown Menus Pointed To Value In Equation
Jul 18, 2013What I would like to do is use a drop down list Type 1, Type 2, Type 3 etc and then be able to use whatever is selected to reference a value in another cell.
Excuse my ignorance but something like Cell 1 * (If Type 1 from the list is selected use figure in Cell 3, If Type 2 from the list is selected use figure in Cell 4..........) etc etc
Given Points On Curve, Solve For Equation
Feb 25, 2009Is it possible in excel to find the equation for a curve?
I have 6 known x,y data points on a curve. I need to find the equation for the curve.
Solving Algebra (Equation) In Excel
Jun 5, 2003How to do the following, which solves the equation, in Excel.
LH
W1
W2
(LH-X)/(LH+X)=W1/W2
(6-x)/(6+x)=.6/1.25
6*1.25-x*1.25=6*.6+x*.6
7.5-1.25x=3.6+.6x
7.5-3.6=1.85x
3.9/1.85=x
x will equal 2.108..... in this case