multiply

Would anyone be wiling to tell me how to write this in an excel formula? IF B9 is not blank, Then IF C7>8, Then "variable1"*C7 Else "Variable2"*C7 Else, 0 In other words, if B9 is blank, return no value. IF it is not blank, then check to...

Hello, Is there a way to take multiply say A1 * B1, A2 * B2, A3 * B3 then put the extended totals add them together and add those up? Like this but without using a third column and just putting the total of 196 in a cell? <colgroup><col style="width:48pt" width="64" span="3">...

Step 1: E, F and G may or may not have an X in the column. When there is an X, i want to total the number of X's in that row, in column H Step 2: I has a $ amount. J, K and L have names for headers. I want the value to be the following: For column J: If X is in column E, then divide...

Hi there! Debut post =) I'm trying to do some calculations but I can only see a long manual way round so looking for a much easier way! What I'm trying to do is work out how much solar energy (kWh) has been generated since the installation date of some solar panels. I have a bunch of dates in...

I would (A2-A1)+(B2-B1) multiply by 65 then subtract this answer from C2.

Hi, I'm trying the following, I have the below data which needs to be copied below this data and each cell if larger than 0 in columns b-e multiplied with the corresponding value in column a. <colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody> a b...

<tbody> Help table Amount Result table 1 2 3 4 5 6 7 8 Name1 5 Name1 1 3 4 5 3 Name2 10 Name2 2 3 4 2 Name3 15 Name3 3 3 3 Name4 20 Name4 4 5 1 1 Multiplied sum 50 100 60 50 125 60 60 40 </tbody> Hello, I need to multiply values from help table with result...

Hi guys! I have a table ("B:G") where the column headers are weeks ("C:E"). And in column G I have different dynamic values. I am trying to multiply the values in range C:E if the criteria in column B is met. So, in short this is what I am trying to do: If value A1 = "dollar" and If column...

I apologize if this is posted somewhere else already, I tried searching but not sure how to describe this function so unsure how to search. I have a spreadsheet for my restaurant's liquor inventory that i was to use to compile the data and turn in for month end inventory. Column A is the...

Hi All, I'm trying to write a formula such that, if the first column is a B, i'd multiple -1 to the counter amount. if the first column is S i'd multiple -1 to the amount column. i'd think a if.. then .. vba should work but i can't figure out whats next. could anyone please help...

I am trying to multiply the cells in one column (Column A) with the cells in another column (Column B). Column B is text, however, each text has a value. Is there a formula to calculate this? For instance, Column A - Rate (various dollar amounts in each cell). Column B is text (Hourly, Salary...

I am new and have never worked with macros. I have 30 different workbooks with cells that have their values in MM and I want to convert all of them to Inches. I will eventually have to do this with a few hundred workbooks. All the workbooks have the cells that need to be converted in the same...

I have a column of totals that I need to multiply by different numbers based on their value. Units that sold $1 to $4,999 in 2015 and increase sales by 20% Units that sold $5,000 to $9,999 in 2015 and increase sales by 15% Units that sold $10,000+ in 2015 and increase sales by 10% I really...

This seems like it should be simple.. All i want to do is if i put in 1 into a cell, that the result stays as 1 But if i put in 2 or 3 in a cell, the result is multiplied by 3. Thanks

Hello All! My deepest apologies if this has already been asked, as I am sure it has, but I am at work and do not have the time to hunt in the past threads. I am not very Excel savvy as I am more accustomed to film work, that said, I am doing some data entry and want to make my job a touch...

Hi, i'm slowly getting there after copying loads of examples and working through modify and create my own code to make a userform front end for a database, i'm almost done but looking back through the code some of the parts i have done myself look a little 'messy' but as they are specific to my...

what is the formula for all column B? such that if A3 value is 10 then automatically B3 value is 10 x 14.5 = 145 likewise if A10 value is 30, then B10 value is 30 x 14.5 = 435 thanks kind regards AK

Hi, Is it possible to format cells to automatically multiply a input value by a fixed number and return the product in the same cell? Can this be done in Excel? Kind regards, Maria

Hello everyone, I want to perform the following function Like i have a value on my Base price text box i.e 2500 I have a value in my Tax amount i.e 2% Now i want my Total textbox to print the value of ((2500 + (2500*2/100)) How do i do it..? Please Help I tried something but its now happening...