multiply

<tbody> weekly salary ee er weeks salary 200-339.99 11.9 23.8 4 340-449.99 17.4 34.8 450-609.99 23.3 46.6 610-759.99 30.1 60.2 </tbody> hello so i need aformula to say if my salary is 600 then use ee b3 also multiply ans by d1

Hi, I am trying to set up a rate spreadsheet. I have a column with distance I need to have the answer be x if between this range, and x if between this range. I have about 5 different ranges. This is what I have tried, but it returns error.( You've entered too many arguments for this function)...

HI - I need to multiply three columns. Each value by each value in all columns: A1*B1*C1 A1*B2*C1 A1*B3*C1... A2*B1*C1 A2*B2*C1 A2*B3*C1...all the way through to A6*B6*C6 <colgroup><col><col><col><col></colgroup><tbody> A B C 1 1 0.5 0.1 2 5 1 0.5 3 15 2 1 4 25 3 3 5 50 6 6 6...

I have a work spreadsheet that I use to upload products and on the discounts section I use this formula: =IF(ISERROR(FIND("Retail",$B2)),SUM(INDEX(Products!$N$2:$N$2000, MATCH($A2, Products!$A$2:$A$2000, 0))*0.5),IF(ISERROR(FIND("Distributor",$B2)),IF(SUM($C2>5),SUM(INDEX(Products!$N$2:$N$2000...

Hi - Newbie here. Read the FAQs, rules and searched the forum and did not find an answer so created a new post. Bear with me if I make a mistake. Question: How do I multiply a negative number by a positive factor and get a less negative number? Hypothetical Example: -2.0 * 1.1 = -2.2. But...

Hi all, Apologies, I'm new to this and new to coding so I will sound as though I'm clueless! Im creating a userform through VBA and I need to get some of the boxes I have created (label boxes) to add up the value that is in the text boxes (in some cases I need them to multiply). Does anyone...

Please excuse what will be a question with the most simple answer, but I'm suffering with Brain Fog today. From the following collection of cells: <tbody> A B C D E F G 1 0.75 2 0.25 0.50 0.75 1.00 2.00 3.00 3 1.44 1.46 1.53 1.68 2.32 3.01 4 50 1.78 1.80 1.88 1.92 2.40 3.22...

Hello, I need a formula to multiply the item in column A as many times as the number in column B in the same row. There are about 150 items in the A column. The formula will have to list in Column C, so many items in column A, how much is the sum of the numbers in column B. Thank you.

Hello! Need some help ... I'm trying to see: If I5 is blank, i want cell S1 to be multiplied by 52 .... If cell I5 is not blank, I want to cee if I5 >S3 ... If this is true, I also want to multiply S1 by 52. Any idea? Keep getting my head turned around. Thanks!

Hi all, This may be a simple fix, but I cannot figure out how to accomplish it. I need to multiply two cells, and put the value in a third cell - sounds simple enough, but when as I need this expression to run across 30 cells, the formula gets messed up. Here's the breackdown: - Tab "Job"...

Hi everyone, I am trying to multiply time by hours. For example 4:00 am x 5 (hours). The result should be 9:00 am, but i can't find a way to get that. Any thoughts? Thanks, Mark

Hi, I don't really know how to describe this too well, but here goes and I hope someone can help me. I have a cell which can have a number in. The number could be for this example, 15000. I want to then have a formula which will only ever take the first 10000 and multiply that by 0.45 and...

I am familiar with this type of IF(AND =IF(AND(G11=10,H11=20),"Yes","No") Can someone please explain what this is doing? =IF(AND(A1="a")*(B1=10)*(C1=30),D1,E50) What is the significance of the multiply? Thanks

Hi, I need to multiply A1 x A2, B1 x B2, C1 x C2 & D1 x D2 and so on, but the answer should come as shown below. <colgroup><col span="5"><col></colgroup><tbody> Expected Answer A B C D Total Weight in gms 1 1gm 2gm 3gm 4gm 2 1 2 2 3 23 3 2 5 1 16 4 2 2 5 28 </tbody>...

I need to determine if a cell is greater than a number then perform one calculation and if its less than then perform a another calculation. Example: If A1 is less than or equal to 500 then subtract 200 and multiply it by 10% or .10 If A1 is greater than 500 then subtract 250 and multiply it...

I need to determine if a cell is greater than a number then perform one calculation and if its great then perform a another calculation. Example: If A1 is less than or equal to 500 then subtract 200 and multiply it by 10% or .10 If A1 is greater than 500 then subtract 250 and multiply it by...

I have a PivotTable with just two fields. I'd like to create a calculated field to manipulate that data. IF the DESCRIPTION field is "Contribution" I want to multiply by -1. IF the DESCRIPTION field is "Withdrawl" I want to multiply by -1. IF the DESCRIPTION field is anything else, I want to...

Good Evening, today I came across the following problem: Say we have a table where the a-column is for example the color of a car, the b-column who sold the car and the c-column is the price it sold for.We now want to multiply the values of all red cars sold by Peter and here lies the problem...

I hope someone can help with this. I can't find anything on the web to help and everything I have tried fails. I need to multiply the figures in column L by 50 if the date in column A was before 01/04/2018 otherwise multiply it by 60. Here is the existing code which I was using prior to...

Hi, I am trying to create a formula that will calculate the number of Wednesdays in a month and multiply it by 28.46. How would I do that? TIA Edited to add: My columns are months: <colgroup><col span="2"><col span="2"><col span="2"><col><col span="5"></colgroup><tbody> JAN FEB MAR...