multiply

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

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

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

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

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

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

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!

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

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

Hello all, Good day. I Have excel file in the below format. Excel 2013/2016ABCDEFG1ValueQTYABACADEFFinal Vlaue2AB1123413AB2222144AC34561155AB4123146AC5134415Sheet1Cell FormulasCellFormulaG2=B2*C2G3=B3*C3G4=D4*B4G5=C5*B5G6=D6*B6 I need get the Final value. If Column A2 = AB then i need...

a simple question what formula to use to multiply the cells in a dynamic range? e.g. A1:A10 =A1*A2*A3..... *A10 many thanks in advance

Please help me write a IF statement to do this If COL X has 10 then multiply by $14.19, if COL X has 20 then multiply by $18.49 I have 8 to sting together. Can a IF statement string 8 different calculations together?

We are trying to create a single column for double checking commissions pays. All the data is on one worksheet The logic would look something like: 'If there are 1-14 lines with the dates of October, then multiply the value in this cell by .01, and if there are 15-19 lines with the dates of...

hello, I'm trying to do the following. If cell A1 says YES then I want to multiply cell B1 and B2 If cell A1 says NO then I want to multiply cell B1 and B3 I would like the results of that formula to go in cell A10 Thanks for your help in advance.

I have googles and test share amount of formulas but going nowhere. I have some blank or non Blank cells in same Column. I am looking for formula if A1 is blank, it can move to A2, pick the amount and multiply it what is in C2, but if there is value in A1, ignore A2 and multiply A1 to C1. I...

Good afternoon, I am trying to multiply a range of cells by a constant number. I am familiar with the SUMPRODUCT but not how to make it work in this instance. Using this formula, {=SUM(M2:M27*{38.46})} I get the desired result. However, how can I substitute 38.46 for a formula or a link to...

I need to calculate some weighted percentages with the following criteria: If X=70% then I multiply 80% of 30% If X=75% then I multiply 100% of 30% If X=80% then I add 10% to the 30% Anything beyond 80% is at most 40%. How do I calculate what this percentage will be if say for example, X =...

ColA ColB 4 1 3 2 2 3 5 3 2 3 1 2 A20 B20 17 14 Sum ColA and Multiply by 3 (17*3) = 51 Sum ColB and Multiply by 2 (14*2) = 28 Then I need to add those 2 values (51+28) and...

<tbody> Projected price Inflation Date Rate 1/1/2019 5% 1/1/2020 5.5% 1/1/2021 6% 1/1/2022 6.5% Price amount by unit Date Amount Desired result 1/1/2019 1,000 1000 x 5% 1/1/2020 1,200 1,200 x 5.5 1/1/2021 1,500 1/1/2022 2,000...

Hi can you say what I did wrong here I want to say if the value in bi is greater than 1384.116 then take bi and minus it from 1384.116 then that result must be multiplied by 70% of the value in c1 then multiply that value by 25% thanks tks Abidh (IFB1>1384.116, then(b1-1384.116)-(.7*c1)*.25)