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 RepliesHow can i format a column of cells so that if a number is less than 10 for eg that that particular cell is then multiplied by 1000.
View 9 Replies View RelatedExcel (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.
Could anyone offer advice on how I would go about accomplishing this task? I'm trying to format two textbox fields on my userform that when the user inputs data into it, it would automatically show the "symbols, dashes and/or spaces accordingling".
The first textbox field (TextBox9) I need to end up looking like this, with the numbers and/or letters changing by user input.
example: (MI) A000-000-000-000
The next textbox Field (TextBox10) I need to end up with this type of result:
example: (MI ID) A000-000-000-0
I was trying something like this but I'm not familiar enough with the formatting symbols to accomplish this task.
I'm a bit stuck with one of my userforms. I have a username textbox on my workbook logon screen. I have put a max length on the textbox to 7 characters. I have also added a bit of code which stops the user from entering anything less than 7 characters (once the commandbutton is clicked, a msgbox comes up), and the textbox will show text in upper case.
What I would like is a way to "format" the textbox. All of the usernames will be in the following format: BBAAA11. The first 2 characters will always be "BB". The 3rd, 4th and 5th characters will be any combination of letters (for example... "CAM", "EAL", "BEF"). Finally the last 2 characters will always be any combination of 2 digits (for example... "76" "24", "00").
If someone could provide me with some code which will not allow the textbox to type anything other than the specified format, or for a msgbox to appear once the commandbutton has been clicked to say that the incorrect format has been entered, I will be most grateful.
I have a userform which writes a date into a cell within a row within a table. The code is
[Code] .....
Everything works fine, the date gets sent to the cell as stated and is all correct. However, I also have vba which runs an advanced filter, which the following code is included in.
[Code] ....
P7 and O7 are the advanced filter criteria. Basically in the form I have a "completion date" which is posted with the first code I posted. So lets say that the date posted is 25/07/14, and I want to have a filter of all the dates which are coming up in the next 7 days to be shown in the Advanced Filter results area of my spreadsheet.
With the second part of code I posted, this results in nothing when using the advance filter. The original posted date in the cell (from the first code) is shown as "25/07/14". So when I run the advanced filter, nothing happens. HOWEVER, if I go to the cell containing "25/07/14", delete the contents and write "25/07/14" manually and then run the advanced filter (second code posted), the date shows up in the results working fine. But I dont understand how me typing it out again makes it work?
I have a timesheet, with a custom format of [h].mm. In my userform, I have a textbox which I would like to use to enter a time in, but when I run the macro, the time shows up correctly (such as 0.12 for 12 minutes), but it is still calculating as text. I've tried all the various codes I have found throughout the board but nothing has worked so far. I can get as far as making 0.12 minutes show as 12.12.00 AM, but then it shows the whole time instead of the 0.12 which the cell is formatted to do and does not calculate it at the bottom where I grab all the times from that column.
View 1 Replies View RelatedHow 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!
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.
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
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%
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 RelatedAfter 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?
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 RelatedI 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.
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.
I've been using the following code to conditionally format userform textboxes based on a specific value (in this case 2490):
[Code] ........
What I'm looking to do now is amend this so rather than use a specific value, to use the value in a specific textbox on the same userform.
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.
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.
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 RelatedI 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)
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 RelatedI 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
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 RelatedI 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
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
I would like to multiply every number in one column with every number in another column with every number in a third column (columns A,B and C).
There are less than ten cells in each column.
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 View RelatedI try to multiply a range with a single value then put the result to another range. But I got the error. range("a1:a10").value = range("c1:c10").value * 5. the error message is the type dismatch. How to do that simple task?
View 5 Replies View RelatedI have a question regarding a vba formula in excel. I am trying to take a whole row ( range) of data and multiply each cell within that range by -1 if a particular cell is an Asset or Liability.
Function AFTER_REFRESH(Argument As String)
AFTER_REFRESH = True
If Range("G5:H5").Item(1, 55) = "LEQ" Then
Range("G5:H5").Value = (-1) * Range("BM5:BN5")
MsgBox "Yo"
Else
End If
End Function
Would I have to use an array?