multiplying

Hiya guys Im after a formula that essentially does a sumproduct but instead of multiplying i want to take away ie im after =sum(B2-A2,B3-A3,B4-A4,B5-A5) etc

Is there a way to multiply every cell from Column D19 through D50 by their corresponding numbers in column G19 through G50 and adding the totals? i.e. =(D19*G19)+(D20*G20)+(D21*G21)+(D22*G22)+(D23*G23)+(D24*G24)+(D25*G25)+(D26*G26)...etc.? I'm doing it long-hand but thought there may be a way...

I have a spreadsheet with peoples hours worked, formatted as [h]:mm:ss Their rate of pay, formatted as 0.0 In order to multiply them together, with the result formatted as 0.0, I an getting random results, does anyone know where I am going wrong ? Thanks Paul

Hi I have a textbox for total amount. I want its value to automatically get calculated from two textboxes (i.e. txt_QtyBought and txt_UnitPrice) by multiplying its values and get displayed on "txt_TotalAmount" But I'm stuck.. Somebody help me please Thanks.

Hi there, I'm trying to calculate an updated cost based on an updated exchange rate (example below) I want to be able to multiply Cell A6 * Cell A2 but keep the solution in Cell A6. The same applies for Cell B6 * Cell B2 etc I have thousands of Costs that need to be applied with the rate and...

I've tried to find an answer here but I actually don't know the correct name (if there is one) for this formulation. What I'd like to do is multiply a cell by say 10% but only if the cell is equal/less than $100.... or... multiply by 5% if the cell is greater than $100. I have a range of...

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

I'm trying to determine the VB for a macro that will replace the values in a column by the the results of the calculation of that same value + (row number/ 100000). At the present, I am creating an additional column and using the following formula: IF(E2>=1, (E2+(ROW(E2)/10000000000)), "")...

I charge one rate for day work and one for night shifts. My spreadsheet is set to figure the total number of hours worked and I know how to multiply by dollars to get answer #1, but is it possible to use a formula to multiply times a different rate for a night shift? For example I use...

I'm designing a userform. I'm multyplying two textboxes together, one of the textboxes is a number and the other one is a percentage. First of all I had problems changing the format to a percentage. If there is an easier way to change the format that works that would be great as well. The code...