Multiply Selection By Percentage
Jun 14, 2006
I am trying to add 40% to a row of numbers? All of which are whole numbers, like 19, 27, 32, 49 and so on and I want to be able to highlight that particular row and add 40% to it, so all numbers in the row have the 40% added to the individual number? So, my new row of numbers would look like: 26.6, 37.8, 44.8, 68.6 and so on....(using same #'s from up top) Is this possible or can it be done with ease? Or do I have to manual calculate the 40% and add it in? I am guessing there is a way to do it w/ a condition but like I said I am complete newbie.
View 6 Replies
ADVERTISEMENT
Aug 21, 2012
I have the following text in B5 "deposit fee 0.75%". I have a value of 3500 in B2. I would like a formula where a can multiply the value in B2 x the 0.75% that is contained in the text "deposit fee 0.75%"
I tried to use =B2*VALUE(MID(B5,17,1)), but it gives me #value
View 4 Replies
View Related
Jul 9, 2014
I 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 Related
Nov 11, 2006
I need the code for a macro that, with a selection, it multiplies the cell number by “x” amount, keeping the original cell format. I know I can do that using paste special but I prefer a macro to be able to use it on different spreadsheets.
View 9 Replies
View Related
May 29, 2009
I'm trying to create a formula that takes from "Manual" Sheet the number from colume G2 and multiply it by the percentage in sheet "AllocationRule".
My formula currently is =Manual!$G$2*AllocationRule!$B5.
What needs to happen is that the total number in "Manual" needs to be distributed evenly in 4 rows by the percentages allocated in "AllocationRule".
Right now I can't copy my formula over to the sheet because the "AllocationRule" should stop at B5 and not go further and the G2 from "Manual" should not change for the percentage allocation but should change to the next row for the next month.
And then after I've done the calculation I want the LOB in "AllocationRule" to be displayed in the LOB in "H1913_H1914" but I'm not sure what formula to use.
View 7 Replies
View Related
Oct 30, 2013
Excel (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.
View 9 Replies
View Related
Apr 3, 2013
I have a workbook that I've built for a project. I've attached a sample workbook. What I'm trying to do, for the entire sheet or workbook if possible, is turn any Cell with a percentage of 30% to 49% yellow and any cell with a percentage of 50% or more Red. I would also like to move the ID's of the variable cells, for example Id number 9922, to the cells beside the description of the rows, Affected would be an example, if the information contained in the same row as the ID meets with a set of variables.
For example I only want the ID's moved if they correspond with IDsub 1-25. One more thing, the people who will be using this spreadsheet will be copying data from a website when it is imported it does not insert the values as numbers. I would like to format the cells, in example workbook they would be any of the cells labeled ID IDsub Variable or Number, so that anything put in that cell will automatically be converted to a number.
I should also probably add that the formatting will be done on approximately 80 rows a sheet with 47 sheets.
View 2 Replies
View Related
Jun 3, 2013
If a user selects certain options from a drop down list created by cell verification (from list), is it possible to display an input box and have the resulting input populate on another worksheet in the workbook? I have an attendance template I'm working with and if a user selects OT (Over Time) then a input box is displayed prompting for how many hours. The overtime is then tracked on another worksheet.
View 1 Replies
View Related
Oct 3, 2006
I tried very hard to design a leave roster for user to mark their leave application. The criteria are as follows:
1. 4 applications per date
2. a region of worksheet (i.e. "A2 to H20) will be defined for users to "click" on the cells (within the defined region) to mark their application.
3. once a cell is clicked (i.e. marked), it cannot be altered.
4. each click will automatically increase the total by 1.
I got the following code to deal with the situation but user can still click on any cell outside the region (in fact I fail to define the region).
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim m
ad = Mid(ActiveCell.Address, 2, 1)
m = Range(ad & 24).Value 'here a formula "CountA(A2,A20)" will be place in the cell (24, c).......................
View 2 Replies
View Related
Jan 30, 2007
I have attached a portion of an excel file I am using at the moment. What I require is a piece of VBA code which will allow me to copy selected data based on a combo box selection. What needs to happen is this :-
If the selection in the "Index" worksheet combo box related to "Month" in cell G19 is for instance "December", I would like the macro to compare this cell value to the cell values in cells C96, C124, C152, C180, C209, C236, C263 and C290 in the "Tech Services" worksheet and where the values match.......copy the commentary (Range C126:Z147 in December's case) to the range C34:Z55.
View 9 Replies
View Related
Apr 26, 2013
calculating the percentage of a percentage and writing the formula for excel.
There are 295 people in a room, of the 295, 75 or 25% are mothers. (I know how to calculate 25% - 75/295 = 25.42) of the 75 mothers 35 have 3 children, 32 have 2 children and 10 have 1 child.
35 is what percent of 25%
32 is what percent of 25%
10 is what percent of 25%
View 3 Replies
View Related
Apr 4, 2013
I am working on a project where user has to select an item from a listbox, however there is a condition that if user select an item, other items of listbox should be disabled so that he/she can not select any other item.
Is there any way to do that as I tried
VB : Listbox.enabled = False
and
VB : Listbox.locket = True
in Listbox - Click/Change but no desirable results got.
View 1 Replies
View Related
Jul 20, 2007
I want to have a drop down list in a cell so that the value in the cell can be only selected from two columns of data. Additionally once the data from the first column has been selected I want to be able to limit the inputs the user can select from in the second column.
e.g. In cell C115 I want to have the value BDS05.
I want to be able to select the value BDS from a drop down list of values and once that value has been selected I want to be able select 05 from a list of values from 01 to 14
If I select BCS as the first value then I want the second set of values to be limited to 01 to 02 etc.
I have read about combo boxes and list boxes and I'm a bit confused about the best way to achieve this (or even if I can).
View 6 Replies
View Related
Feb 7, 2009
How can I multiply a range with a value and put the value in another range, using VBA ?
I have in some cases 2000 -3000 rows and I need to automate the process.
Please open attached file!
View 6 Replies
View Related
May 22, 2008
I have a table with data which I have entered with VBA, now the only thing missing is multiply column D with column E.
When the data gets put into the table I like the data in column E to be multiplied with the date from column D.
View 9 Replies
View Related
Aug 10, 2006
I am having trouble creating a formaula to calculate value based on the sum of a cell. For example if the sum of cell A1 is <= 149 I need to multiply the sum by 1.0
if the sum of cell A1 is 150-199 I need to multiply the sum by 1.50, if the sum of cell A1 is 200-249 I need to multiply the sum by 1.75, and if the sum of A1 is >= to 250 I need to multiply the sum by 2.00
View 3 Replies
View Related
May 18, 2009
b25
if the amount in b7 is the same or less than 7495 i need it to be multiplied by 10%
b26
if the amount in b7 is greater than 7495 then i need it to multiply the diference by 20%
View 14 Replies
View Related
Mar 12, 2009
I want to be able to enter a value into a cell (within a specified range if necessary) and have it automatically multiply by a set value and overwrite the original entry with the result so making it all happen within one cell.
View 9 Replies
View Related
Jun 9, 2006
After ripping a .pdf report into Excel I am left with a variety of items in Column A, numbers as text, text, and blanks. I manually selected entire column and paste special multiply. Seems to have convereted blanks to zero, converted numbers stores as text to numbers, and ignored any text. Problem is writing macro to repeat the steps as will use the tool every period. I tried looping through the range
For Each C In myRange
C.Value = C.Value * 1
Next C
But this returns type mismatch error. So why did it work manually if won't work through the macro?
View 2 Replies
View Related
Nov 27, 2006
I have 3 columns. A B and C. In column C I want to input the answer to a formula into each cell using data from cells in their respective rows,
For. e.g.
Cx= Ax- (Bx X 0.8).
I want to be able to input this formula somewhere that will automatically fill out the cells in column C.
Column C is 20 cells long so x would range from 1 to 20.
View 5 Replies
View Related
Mar 2, 2008
I'm having difficulty in summing multiple rows (order volume) over many columns (despatched volume) that have a specific constant (price for the week).
Please see spreadsheet attached. I would like row 19 to be achieved as one line, thus removing rows 14-18. see logic in rows 14-18 which drives the row 19 result.
The problem is the volume is over 52 row and the price is over 1 row. Cannot think straight as to how to build the array. No VBA as the result needs to be transparent from a formula.
I'm having difficulty in summing multiple rows (order volume) over many columns (despatched volume) that have a specific constant (price for the week).
see spreadsheet attached. I would like row 19 to be achieved as one line, thus removing rows 14-18. Please see logic in rows 14-18 which drives the row 19 result.
The problem is the volume is over 52 row and the price is over 1 row. Cannot think straight as to how to build the array. No VBA please as the result needs to be transparent from a formula.
View 9 Replies
View Related
Feb 8, 2009
I have a cell that is "Start Time." Another is "End Time." And, of course, "Total."
The sum listed in "Total" is multiplied by a cost per hour. Except it does not work. I have attached an example copied directly from the cost sheet.
View 3 Replies
View Related
Aug 8, 2014
I have column A that declares the account as asset, liability, expense, etc. Some of the accounts need to be reversed. I'm having a hard time figuring out a formula or code I can use. Column C contains the values. I prefer VBA as I want to add it to the current macro I already have.
So if Column A has a liability, offset by (0,2), and multiply that value by -1. If Column A has an asset, leave the value as is.
I wanted to use an if-then statement but I'm not sure how to highlight entire columns. The number of liabilities, and assets, etc.
View 7 Replies
View Related
Apr 15, 2009
In my macro, I'm trying to use an input box to determine the factor to multiply another cell by. I also want to only allow entry of 6.0 or less, and only allow, (but not require), a single decimal place. Here's what I've got so far, but it's not working:
View 2 Replies
View Related
Jun 16, 2009
On my Userform i have 2 textboxes. Textbox2 needs to look at textbox1 and if the value in textbox1 is equal to or greater than 25000, then multiply that value in textbox1 by 0.0035 and place the value in textbox2.
View 4 Replies
View Related
Mar 1, 2007
I 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)
View 9 Replies
View Related
Oct 24, 2009
I have a row where C5 is the total of C1:C4. What I am trying to do is if C1 or C2 or C3 or C4 has a number value that I can multiply the cell in question by 2 and then add up all of the cells to give a total in C5. Also, I have a name in A1, but when I select E1 and enter =A1 into the cell then return, I get A1 in the cell instead of the name in A1.
View 5 Replies
View Related
Jul 14, 2014
I need a VBA macro to multiply column E and F and deposit the result in column G. The multiplication should only happen when there is a value in the column E. If there is no value in the column E, then the cell in the G column should stay blank.
View 9 Replies
View Related
Dec 9, 2009
I have 3 sheet.
i need to multiply the value sheet 1 and sheet 2.
Sheet1 AB1NameAmount2Kumar1003Siva2004Sasi3005kannan400 Excel tables to the web >> Excel Jeanie HTML 4
Sheet2 ABC1Name MonthComments2kannan5good customer3Kumar10average customer4Siva20ok5Sasi25not bad Excel tables to the web >> Excel Jeanie HTML 4
The answer should be like this
Sheet3 ABC1NameAmountComments2Kumar1000average customer3Siva4000ok4Sasi7500not bad5kannan2000good customer Excel tables to the web >> Excel Jeanie HTML 4
View 9 Replies
View Related
Jan 18, 2010
I need to multiply text box value and Combo box value, but facing with "Run time error-13,Type Mismatch"
Dim total as Integer
Me.txtQty.Value = ""
Me.txtAmount.Value = Total
Total = txtQty.Value * cboRate.Value
View 9 Replies
View Related