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


    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...

Some videos you may like

This Week's Hot Topics