multiply

Hello, I want to multiply the numbers from 2 table but only if they match T1 data : {"a123";"a124";"a125";"a126";"a127";"a128"} T1 values: {11;12;13;14;15;16} T1 criteria: {"a123";"a125";"a128";0;0;0} in order to keep T1's number sequence I used the formula (...

Using this code to get rid of extra character but then need to multiply by 1 to calculate dates correctly...I'm still actively working it... Public Sub Remove() Dim oCell As Range Range("B8:BU172").Select For Each oCell In Selection oCell.Value =...

Hi all, I have a lot of columns in excel that I want to multiple by the same number, but want to do it in the same cells without having to create new sheets etc. I found the Paste Special + Multiply option. It does the job, but it increases the size of my excel sheet by a significant number. It...

Hi, I need to multiply and then sum in Excel 2013 two columns D and K based on the name "BOOK" which is a part of the string in some rows of column C. I´ve tried this formula below but no avail. What´s wrong there? =SUMPRODUCT(D6:D50;K6:K50*(C6:C50="*BOOK*")) Thx in advance!

<tbody> Acct Name Return 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 </tbody> I have a long list I'm trying to apply this formula too but cannot figure it out. I need to...

I am trying to accomplish in Excel following case but I am not able to make it work. Could you please help? I have got given volume data for asseblies (as example Ive choosed bikes) In second part of table I have number of parts needed for each assembly The task is to calculate quantity...

Hi Experts, I am using following code in a Form Control - Scroll Bar to get Min & Max value from a cell (has formula) to another cell as values. My Cell Value varies between 0 - 50,000... I believe scroll bar has a limitation up to 30,000 hence I am dividing my values by 10. Eg: 50,000 to...

Hi All, I am very much new of using advanced excel I have the below requirement Insert * symbol from the list and multiply with a number I was able to achieve this followed the below procedure Insert numbers from 1-10 and in one column use data validation and pick Allow List and input the...

Hi, in a template, i want people to complete an amount in cell L23. If this an amount is added, i want excel to multiply this amount by 3 and overwrite the original amount. Is this possible in VBA? Thanks!

Hello Folks,I have a very complex requirement. I need a macro to multiply based on some conditions. I have a two column one is filled with "Y" and "N" letters another one is filled with numbers. My requirement is to identify all the "Y" succeeded by "N" and multiply the value of adjacent cell to...

Hi All I have 15 text boxes in my userform that i want to multiply by a corresponding text box and total in one text box Example quantity is one text box (textbox37) and cost is the other textbox (textbox52) i want to multiply them two together but need to do this for all textboxes to get a...

I have used the formula below to get a specific set of cells to produce a multiplied figure, however it will only work for one row. Each time I change the details in the formula to include another row it deletes the info that was added for the previous row. Is there a way to use the formula on...

Hi all! I have a series of columns on a sheet with data in, running down the page. I'm trying to come up with a formula which does the following but I'm struggling: - if the value in row 41 is the same as one in fixed cell $B$38, then multiply the value in this column, row 63 with row 66, and...

hi i have three different rates for one product a= 10rs for 5nos and for 10nos rs30 and 15no rs40 i want a formaula when i type 5 in one cloum it should automatically multiply with rs10 and rate shd reflect in colum.. like wise if customer select 10 and 15 it shd multiply with 30 and 40 can...

Hi There, I have an IF statement that currently has 10 IF statements within...

Hi all, It's my first post and I hope I can learn and add value to this platform. I'm stuck at this issue and im not sure if there is a way to do it more efficiently. As mentioned in the title, I am trying to sum multiple columns and multiply the results with a third column. in another word, I...

Hello Experts, i have a question multiply based on conditional cells. required to get the Bonus by multiplying QTY by value, this value based on user and task example if user1 and task1, multiply the entire QTY by 15 if user2 and task1, multiply the entire QTY by 10 can any one help ...

Hello, I am trying to have a formula multiply two separate parts of a single number that is in a single cell. i.e. I have the number 14, I want a formula to know that any number less than or equal to the number 8 is to be multiplied by the Straight time rate and any number greater than 8 will...

Hi is it possible to use the grand total of a measure in another measure calculation. For example , in the table provided I want to multiply my FCST column by the grand total % in my Measure 1 column (22.24%) and the % ALP column ( 12.99%).(Measure 2)...

Hello, I am trying to use the IF function to perform a calculation. I will try to outline the scenario below. A sheet called 'Outputs' has monthly data, running from Sep-17 in cell T36 to Aug-27 in cell EI36. Another sheet called 'Analysis', in which the formula is going, has the same monthly...