multiply

  1. P

    Efficient multiplication in VBA with macros

    Hello friends, I am trying to create a code that is as efficient as possible. What I need to do is Multiply a range of cells by a fixed value and then replace the value that each cell had with that new value. For example: In the "D5: 25" range I have different numerical values in each of the...
  2. H

    Multiply then copy

    Hi - Is there a way to use a macro to multiply .Range("P" & .Rows.Count).End(xlUp) and ws1.Range("A10") then paste the value in ws1.Range("C10")? I guess I could use .Formula, but I was also reading about PasteSpecial and xlMultiply. I just haven't been able to figure out how exactly to use...
  3. A

    excel 2002 convert numbers to mathematical

    i copied numbers from an online account. pasted them into excel 2002. how do i convert the numbers to numbers i can multiply etc? i tried putting a 1 into a cell then copying and paste special multiply tried converting the cell to numbers thanks all
  4. I

    How do I look up two criteria and then multiply the result?

    hi all, i am looking to match two separate criteria listed on tab 1 to a table of rates on tab 2. i would like to find the rate and then multiply by another number back on tab 1. hopefully that makes sense. i assume an index, match would work, but not sure how to take advantage of 2 criteria...
  5. M

    Nested ISBlank

    Hello I have 3 cells I would like to check if blank So if Cell B19 is blank check Cell B25 if not blank multiply B19*15 (then equation is done if its not blank, if blank go to next cell) If B25 is Blank go to Cell B27 if not blank multiply B27*10 (then equation is done if not blank, if blank go...
  6. M

    Multiply Input Cell by Another Cell

    Hi There, I'm trying to multiply a cell within a table that I would input a number into by another cell and struggling with the VBA formula. For example, I would input 5600 into F2 and want it to multiply by D2 and display the result within F2. <tbody> A B1 C D E F G 1 material Desc...
  7. S

    Formula in excel

    I think I need to use an IF formula but can’t work it out. I have F4+E4 to give me the G4. So i have a few different hours so I need the formula so that if G4 is equal to or greater then 8 then the remainder hours calculate to multiply by 1.5 Can anyone help please?
  8. F

    Complex IF formula

    I'm struggling with a complex IF formula, hoping someone can help. In D2 I have a category number 1-4. In F2 I have a number which could be positive or negative. I need a formula in G2 to work out the following conditions: IF F2 is 0, G2 = 0 IF D2 = 1 AND F2 is GREATER than zero MULTIPLY...
  9. P

    Multiply a number by a range

    Hi, I am not sure how to proceed with the formula as I want to multiply a number by a percentage range ie: 65%-85% of 200, I would want the cell to populate with 130-170. Thanks for your help! :)
  10. A

    using VLookup tables and then multiply another number

    Hi, everyone!! I'm excited about this forum!! I love Excel and it's endless features! I was wondering if anyone could help me out ... hopefully this is an easy question/answer! I'm trying to create an Excel Spreadsheet with a vlookup table, and I can't figure out the correct formula - but i'm...
  11. M

    Multiply each row with another all rows

    Hello,</SPAN></SPAN> I got some results in the columns C:E in this example there are 4 rows</SPAN></SPAN> And some results in the columns G:I in this example there are 6 rows</SPAN></SPAN> I need to multiply each row of Column C:E with all rows of column G:I so it will be 4*6=24 rows as shown...
  12. G

    IF? for a result?

    Sometimes a formula that should be so simple really gets the best of me. Can some advise me of what I'm doing wrong? Below is the formula.... =IF(H9="2",(D9*13)),IF(H9="3",(D9*20)) All I'm trying to do is where ("H9="2") is to multiply the formula, then if (H9="3") then multiply that formula...
  13. adrienne0914

    SUMIF or SUMPRODUCT

    Hi all, I am trying to figure out the best formula for this problem. My workbook is more complicated, but in a nutshell here is what I'm trying to create a formula for: Data Tab <tbody> ANIMAL COUNT Cats 18 Dogs 245 Rabbits 17 </tbody> Animals tab <tbody> Cats Y Dogs N Bears Y...
  14. W

    If Formula to calculate cell with value

    I am trying to create a formula that will create a result for a cell if a range of three cells has a value: IN K6-------> IF D6 contains value multiply G6 by 15 IF E6 contains value multiply G6 by 15 IF F6 contains value multiply G6 by 10 Each row (6-xxxx) will have a value in ONLY one cell...
  15. V

    excel vba to multiply columns using header names

    Please help me to find a vba code to multiply two column data using its header names (column will vary each time) Eg: Two columns with header name "Unit Price" and "Quantity". The sum should be multiplication of these two columns. regards Varghese Mathew
  16. R

    formula help

    I need so assistance with a formula. I am trying to use and if statement to determine a amount. I have a column that has a value of 1,2,or 3. If the value is 3 I need to take the amount in another column and multiply it by -1. Also if the value is 1 but the amount is already a negative...
  17. T

    Am I missing something in my Formula

    I am creating a spreadsheet to track a monthly absent rate between 5 different teams. Employee numbers range from 35-17 and average monthly work days range from 14-19 per team. I take the number of employees and multiply it by the number of days that the team is scheduled to work. I take the...
  18. P

    Nested If Statement with Calculations

    I need to enter a formula in a cell that does the following: If S2= ‘L’ then multiply V2 by W2, If S2=’R’ then multiply T2 by U2, If R2 =’S’ then multiply X2 by Y2. Thank you very much to anyone that can help with this!
  19. M

    Multiply h:mm:ss?

    I am trying to multiply 0:35:15*1000 and I keep getting the result of 11:30:00. What am I doing wrong?
  20. D

    If cell is given background color then sum

    Hi all. First time poster here. I've used this site for quite a while to increase my Excel abilities and I thank you all for your great insight. This seems like it should be simple, but it has me scratching my head. Hopefully, someone can help me out. I am looking for a formula that would...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top