multiplication

  1. C

    Multiplication Based on Cell Color

    Hey all! Hoping someone here is a bit smarter as I've ran into a mental roadblock. My Worksheet: I have a inventory worksheet with 4 columns (ID, Product Name, QTY, Total Price) and 788 rows. We are offered pricing based on the "QTY" column, for example 1-10 is $55.00, 11-50 is $25.00. I will...
  2. S

    If a cell changes, multiply it by another cell.

    This may be tricky. I have a spreadsheet with several columns of numbers for sales data. If the cost of an item goes up, I want to be able to enter that cost and have it automatically multiplied by a markup factor contained in another cell. For this instance, my range is C3:L25 and the...
  3. D

    New to Excel need very simple help, thanks

    I'm guessing this is very simple but cant seem to figure it out, I need to total the tonnage of each different type of product and put it in the table to the right. Can only seem to get it to tally the products , how do i get the sum of each product's individual tonnages? So i get a total...
  4. leopardhawk

    Need to add multiplication to an array formula

    Hello forum friends, I am trying to add a multiplier to an existing array formula but it is giving me, not an error, but the wrong result. The formula as it exists is returning a result of 24. I want to multiply this result by 0.621371 but when I add *0.621371 to the end of the formula and do...
  5. J

    Adding Paranthesis Around Multiplied Numbers in a Textbox

    Hi, I need help with creating a code where in equations that I am making, parenthesis would go around the multiplication, just like in the picture below. Here is the photo: https://imgur.com/a/kJ1YAMM
  6. Z

    Multiplication

    This probably sounds very simple but I'm stumped. So in the first column I have my mileage rate which is 0.25p per mile then I my full row of values of mileage (300, 180, 120). Then the last cell of the row I want to multiply each value by my 0.25 to give me a total. I've got it to work by...
  7. M

    Performing math function with cells containing numbers & text

    Greetings, I need some help. Am perform basic multiplication between two cells, one containing numbers & text. Example - Cell A1 - contains the number 5 Cell A2 - contains the words "5 days" Cell A3 - I'd like to multiply A1 times A2 and come up with 25. The word "days" in A2 is creating...
  8. R

    Position(s) of the Large after multiplication

    <tbody> </tbody> In my example I've got components of 5 combinations in B5:C9 to be multiplied, Extra is added to each of the B5:B9 and C5:C9 array(s) when calculating the Largest product of those arrays. Instead of listing the results of the multiplication I'd like their...
  9. R

    Error When Formatting TextBox Value To Then Perform Another Action

    Hi Everyone, I have A UserForm With 3 TextBoxes - TextBox1, TextBox2, TextBox3 (To Make This Example Simple) I have the following codes in TextBox1: Private Sub TextBox1_Change() Me.TextBox1.Text = Format(Me.TextBox1.Text, "#,###,###,###") TextBox3.Value =...
  10. K

    Need Vloopkup Formula for Multiple Creteria + nested cells + multiply x between 2 dates

    Hi Trying to create formula foe the below table which has multiple criteria x Qty x Duration (with two dates) Attached sample file: Eg for Apple. Same as vlookup to be made for all items like carrot, beans, tv from nested cells. After this, the results will be converted to Pivot table /...
  11. L

    =40/2*16

    Hi The result of above formula is 320? Why division has higher priority than multiplication? I thought the order of Operations is PEMDAS So M before D?
  12. F

    Multiplication by percent

    Hi, I have values: <tbody> Values (col a) Percent (col b) Result (col c) 20 2 20.4 30 5 31.5 10 40 10.4 </tbody> equation should looks: result = 20 * 1.02 = 20.4 result = 30 * 1.05 = 31,5 result = 10 * 1.4 = 14 How can I do it into Vba? Because I doing now as below: (result is the...
  13. K

    Excel formula needed which includes multiplying or returning text

    Hi all, I wonder if someone could help me with a formula. I have 2 columns which will either have a number in it or text "Not applicable" such as: 2 2 3 3 2 Not applicable I need a formula which will multiply the 2 numbers together or return Not applicable if that is what is...
  14. L

    Multiply number by text

    I am trying to create combinations and I have a matrix that look like that: <tbody> E W O N 1 2 0 3 3 2 1 1 1 2 0 0 </tbody> I want to have it look like that: <tbody> 1E-2W-0o-3N 3E-2W-1o-1N 1E-2W-0o-0N </tbody>
  15. CyrusTheVirus

    SUMPRODUCT Issue

    Hi everyone, I guess I don't seem to understand the SUMPRODUCT function enough in terms of separation of arrays by a 'comma' or by a 'multiplication' sign. Here's my issue: I do not understand why when using SUMPRODUCT and a '*' (multiplication sign) to join the array calculations the formula...
  16. A

    Performing math operations on query results

    Hello all....I need to know how to perform math on query results...Here's what im looking at in the query Area1 3 8 Area2 4 8 Area3 5 8 Area4 2 8 Now here's what I need it to do, firstly add up the first column Area1 3 8 Area2 4 8 Area3 5 8...
  17. S

    How do you add multiple cells quickly

    Hi, I am trying to add multiple cells without having to use the (=A1+A2+A3+A4 etc) manual process, What is the quick way to do this? Thanks in advance
  18. J

    Matrix Multiplication using VBA

    To see What I want: http://tinypic.com/r/15s4haq/8 I want a VBA that will multiply Matrix A to Matrix B and store the Answer in Matrix C. I want a VBA that will multiply Matrix C by 8 and store in Matrix C If it is possibe, could you give me funcitons to be aware of in Matrix vba, like...
  19. L

    Multiplying with zeros formula help!

    Pretty new to excel so bear with me. Have to complete a table that responds to different values. I have a basic formula that is: =B18/B16*60 and i want it to be able to change in response to another cell and look like =(B18/B16*60)*B19. However I want B19 to be left as zero without making the...
  20. J

    use If formula to match unit of measure and then multiply or divide

    So here is my issue. i have items that our system looks at in basic units i.e. 100 bandaids in a box, 10 boxes in a case, etc. what i need to do is find out a way to figure out how many onhands we have of a PURCHASE UNIT. not necessarily in basic units and then multiply that by the purchase...

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