This tutorial shows how to use the multiplication operator in Excel and how to write a formula to multiply cells, columns and rows, numbers and percentages, and more. Continue reading
by Svetlana Cheusheva, updated on
This tutorial shows how to use the multiplication operator in Excel and how to write a formula to multiply cells, columns and rows, numbers and percentages, and more. Continue reading
Comments page 2. Total comments: 142
I have to know the excel formula for multiply more the three currency with one column
for e.g.
A
USD 100
B
AED 100
C
Eur 100
D
Exchange Rate
E
If the rate of USD is there I have to calculate with D exchange rate
If the value of C is AED is there then I have to Calculate with D exchange rate
How should I multiply this with excel formula?
Pls help
Hi!
If I understand you correctly, then in one cell D1 you want to write 3 exchange rate values. This is not possible in Excel. You can use the VLOOKUP function to select the desired exchange rate based on the currency. If there are a total of 3 exchange rates, write them down in separate cells (for example, F1:F3), and use nested IF function:
=IF(A1 < > "",F1,F(B1 < > "",F2,F(C1 < > "",F3,"")))
I hope it’ll be helpful.
INVOICE CURRENCY VALUE IN USD
USD INR AED EX RATE
$5,987.27 1.00 $-
Can excel complete a calculation for multiples of say 7. So you start obviously with 7, then have it auto generate out 14, 21, 28, 35, etc? And control its start and end number so if you wanted to start at say 336 and have it provide multiples of 7 generated out up to at least 1,000?
Hello!
You can create the sequence you want with the SEQUENCE function. See instructions and examples: How to make a date sequence in Excel with a formula.
I hope it’ll be helpful.
Hi,
How do I multiply a whole row by the same number?
Eg. All of row B needs to be multiplied by -1.
How would I do this
Thank you
Hi!
If you're talking about B, then it's a column, not a row. Please have a look at this article - How to multiply columns in Excel.
You can use this formula:
=D1:D13*(-1)
If you have a columb of numbers, how can you set excel to multiply a specific value inside the column. Example every time a Columb has a consecutive 0 in it I would like to multiple by ($100 or the growing balance by 2 until the next number isnt 0). Thanks for input.
Hi!
Your question is not entirely clear, please specify.
Hi,
I am trying work out commissions and by typing 'Y' next to the commission type. Buy i would like to know how much commission is accumulated at the bottom. Is there a way to create a formula that times' the amount of 'Y' but an amount?
Thanks :)
Hi!
The information you provided is not enough to understand your case and give you any advice, sorry. Please specify what you were trying to find, what formula you used and what problem or error occurred. Give an example of the source data and the expected result.
Hi,
How can I count a sum of multiple values where some have different percentage multipliers. E.g
A1:A1000 have different numeric values. The sum of these values is a percentage (eg. 60% x sum of values). BUT some specific values e.g. 89$ should be calculated with another percentage (70%.) How do I create a formula that calculates all values with 60% except 89 dollar values (with 70%) and adds them all up?
Hi!
To conditionally multiply, use SUMPRODUCT function:
=SUMPRODUCT(A2:A1000,IF(A2:A1000=89,0.7,0.6))
How do make the column multiply by itself without having to input the formula?
Hi!
This can be done with a VBA macro.
I'm looking for a formula that will multiply a cell by .25 but only the first 50 counted in that cell. So if the cell is say 65 I want it to only multiply 50 by .25.
Hi!
Use condition with IF function:
=IF(A1<=50,A1*0.25,50*0.25)
This should solve your task.
Trying to multiply the following cells with the following numbers in the cell. Example as follows...
Cell.. AB1 (has the number 231 in it)
Cell.. AC1 (has the number 2.529 in it)
The 231 is fuel and $2.529 is the cost per gallon and I need the total costs of the fuel
How to multiply rows with different multiplier
eg:Value X
Multipliers - 1,2,3,4,5
looking formula for x*1,x*2,x*3.....
Hi!
What do you want to calculate exactly? Your question is not entirely clear, please specify.
I want to one formula people age.
If current time and date in one box fix.
One column is date of birth. One column vale is either death or alive. If people die results show zero.
Hi!
Here is the article that may be helpful to you: How to calculate age in Excel from birthday
A B C D E
1 SAKO Portier Cleaning %
2 Adam 21.8
3 Thomas 15.2
4 Jack 11.0
5 John 11.0
6 Smith 12.2
7 Jef 8.4
8 David 20.6
9 Total 3400 5500 7300 100
Hi
Could you please provide me with an excel formula to fill out the above Excel matrix by distributing the items in total row among the persons by using the percentage stated in the column. Many thanks for your kind cooperation
Hello!
Please check out the following article on our blog, it’ll be sure to help you with your task: How to calculate percentage in Excel
The formula in C1 might be something like this.
=B1*$C$9
Copy it down the column.
If there is only one value at the time of multiplication, then there will be a specific mark in the cell, How to do it in Excel?
=IF(L20=9,(M23*0.9+K14*0.15))
Didn't seem to post the formula correctly
I have 2 formulas, they work by them selves but when I try and add them together it will not work, What am I doing wrong.
=IF(L20=9,M23*0.9+K14*0.15)
Thanks
how to multiply B3?
19.46 * 8000 is giving me 155,652.91 but the real answer is 155,680. Why is excel giving me this number?
Hello!
I assume that 19.46 is the result of calculating the formula, and not entering this value manually. If you increase the number of decimal places in the number format, you will see that this is not 19.46 but 19.45661375
You can use the ROUND function in the formula so that the number on the screen does not differ from the real number.
Here is my example: My balance is $1045.00. My rate is 4.5%. My minimum payment is $45.00. I plan to add an additional monthly extra payment of $400.00. I can figure this out on Excel spreadsheet by using a running balance, monthly interest, and the monthly payment. I want to be able to calculate this on paper to get the future amount owed or total interest paid without calculator. Thank you in advance.
I need to multiply one cell by another, repeatedly where only one changes. So, I want C3 * D2, C4*D2, C5*D2, but when I put in the first formula and drag down the column, it gives me C3*D2, C4*D3, C5*D4 -- it changes the second number. I have tried putting a $ before the D value =PRODUCT(C3*$D2) but it does not help. I want the D2 to remain constant and each C to multiply by the D2 number.
Hello!
Here is the article that may be helpful to you: How to copy formula in Excel with or without changing references.
=C3*$D$2
I hope this will help.
Total $784,802.74
Contracting fee 15% + gst $117,720.41 -need this formula to also include the GST IE: =+B55*15% +(B57*5%) - wont let me do this in current column. Circular reference error if i do this? The amount should be $123,606.43
Estimated - New Budget Total $902,523.15 This total would then be: $908409.17
Hello,
I want to calculate:
(1+Q13*$N$2)+PRODUCT(1+Q13:Q14*$N$2)+PRODUCT(1+Q13:Q15*$N$2)+... +PRODUCT(1+Q13:Q33*$N$2)
is there any shorter way I dont need to write them all?
Hi,
Unfortunately, without seeing your data it is difficult to give you any advice. Could you please describe it in more detail? What result do you want to get? Please provide me with an example of the source data and the expected result.
multiplication function for these cells: N11, N12, N13, E14, and E15
Thank you!
My problem is simple, in A column is a, b, c, d, e, f, g repeate randomly up to millions, corresponding value 3, 5, 4, 6, 2, 7, 1, 8 randomly, multiply with colum B, Each cell value is different, more than two lac.... please solve my problem with exact formula wth helper.....
Hello!
Your explanation is not very detailed, but I think the article will be useful to you: Excel random selection.
I hope my advice will help you solve your task.
Hello.
I am sure this is a simple problem. IF statement to multiply part of the value by a %, but there are parameters based on value reaching benchmark. Please see a simple example below.
Cell value: $100,000
If cell value is between $0 to 10,000, 8%.
If cell value is between $10,001 to 15,000, 10%.
If cell value is $15,0001 to 20,000, 15%.
If cell value is $20,001 to 25,000, 20%
como multiplicar si el precio trae decimales pa que despues no salvation value
I NEED ONE ROW MULTIPLY BY SECOND ROW AND FORMULA COPY IN OTHER ROW WITHOUT CHANGE
Hello!
I’m sorry but your task is not entirely clear to me. For me to be able to help you better, please describe your task in more detail. Please specify what you were trying to find, what formula you used and what problem or error occurred. Give an example of the source data and the expected result.
It’ll help me understand it better and find a solution for you
My question ( 0.89+0.88+0.87+0.87+0.86+0.86+0.85+0.85+0.84)*7.06 +(0.83+0.83+0.82+0.82+0.81+0.81+0.80+0.80+0.79+0.78+0.78+0.77+0.77+0.76+0.76+0.75)7.57 /(0.89+0.88+0.87+0.87+0.86+0.86+0.85+0.85+0.84+0.83+0.83+0.82+0.82+0.81+0.81+0.80+0.80+0.79+0.78+0.78+0.77+0.77+0.76+0.76+0.75) My ans. 59.53 but actual ans. 7.3765
My Formula = =SUM(F11:N11)*7.06+SUM(O11:AD11)*7.57/SUM(F11:AD11) Please suggest right ans.
Hello!
Your formula:
=(0.89+0.88+0.87+0.87+0.86+0.86+0.85+0.85+0.84)*7.06+(0.83+0.83+0.82+0.82+0.81+0.81+0.8+0.8+0.79+0.78+0.78+0.77+0.77+0.76+0.76+0.75)*7.57/(0.89+0.88+0.87+0.87+0.86+0.86+0.85+0.85+0.84+0.83+0.83+0.82+0.82+0.81+0.81+0.8+0.8+0.79+0.78+0.78+0.77+0.77+0.76+0.76+0.75)
=SUM(F11:N11)*7.06+SUM(O11:AD11)*7.57/SUM(F11:AD11)
Answer: 59.549
Formula:
=((0.89+0.88+0.87+0.87+0.86+0.86+0.85+0.85+0.84)*7.06+(0.83+0.83+0.82+0.82+0.81+0.81+0.8+0.8+0.79+0.78+0.78+0.77+0.77+0.76+0.76+0.75)*7.57)/(0.89+0.88+0.87+0.87+0.86+0.86+0.85+0.85+0.84+0.83+0.83+0.82+0.82+0.81+0.81+0.8+0.8+0.79+0.78+0.78+0.77+0.77+0.76+0.76+0.75)
=(SUM(F11:N11)*7.06+SUM(O11:AD11)*7.57)/SUM(F11:AD11)
Answer: 7.376
You can choose yourself.
Hi, I need help in Excel. I have a column of 22 services rendered, then the cost of the service in the next column, then the # of times the service is rendered in the next column. The rest of the columns across the spreadsheet I have columns for Sunday through Saturday for 1 week. For each service can be performed zero to 8 times a day. I am trying to create a formula to multiple the cost of the service times the number of times it is performed a day.For example cost of service, which is $3.00 is in cell D5, the number of times service is done, which is 3 times, is in cell E5 and in cell F5 I put the formula =Product(D5*E5) which gives me the total cost of the services rendered for that service for that day which is Sunday in my spreadsheet and the total is $9.00. If this same service was done on Monday, but for 6 times,I can not figure out how to set the formula so it does not change the correct amount for Sunday. I need the spreadsheet to show the correct amounts for each day of the week as the number of times the service is done changes or may change each day. If I use the formula =Product (D5*E5) in the cell for each day it gives me the same amount for everyday even when each day the number of times the service is rendered is a different number. How do I adjust the formula to show the correct amount for each day for the services rendered that day?2020
MONTH WEEK
#: Homecare Services Cost of service # Service done SUN MON TUES WED
1 Check on client $3.00 3 $9.00 $9.00
2 Assist/escort to Activities or meals $7.89
The services done daily change in number daily; in the above example Sunday it was done 3 times; but Monday it was done 6 times; how do I write the formula to change with the number of services done each day to get the right amount daily? Monday should not be $9.00, but $18.00 since it was done 6 times. Thank you for your help.
Hello Karmi!
If I understand your task correctly, the following formula should work for you:
=SUMPRODUCT(D2:D5,E2:E5,--(F2:F5="sun"))
I hope it’ll be helpful.
Hello,
I am trying to use a formula to track supplies. In this instance I would want to track full cases of an item as well as individual items.
I have my data set up where C:C would be cases and be required to be multiplied by 8
D:D would be individual boxes. What I would like to do is have an equation that would essentially mirror this 8*(C:C)+(D:D) but I haven't been able to figure out the proper way to organize it that excel likes. I've tried SUM, PRODUCT, and SUMPRODUCT to no avail.
Please help.
Hello Caitlin!
I’m sorry but your task is not entirely clear to me.
For me to be able to help you better, please describe your task in more detail. Please let me know in more detail what you were trying to find, what formula you used and what problem or error occurred. It’ll help me understand it better and find a solution for you. Thank you.
Hi,
I'm trying to create an excel spreadsheet to help me take inventory at packing shed for onions. The onions are palletized (42/pallets). I was to be able to type in the number of pallets and it automatically multiple by 42 to calculate the total number of bags.
Hello John!
I hope you have studied the recommendations in the above tutorial. Please let me know in more detail what you were trying to find, what formula you used and what problem or error occurred. In that case I will try to help you.
How do I calculate in the following excel sample:
A B C D E F G
1 Rate--> 8 11 6
2 Block Apt Item 1 Item 2 Item 3 Amount
3 1 GA John Peter 2 0 0 ?
4 1 1B AAAAAAA 1 2 3 ?
5 1 2A BBBBBBBB 2 2 5 ?
6 1 2B CCCCCCCC 0 0 2 ?
7 1 3B DDDDDDD 0 0 3 ?
8 1 5B EEEEEEEEE 1 1 2 ?
9 1 6B FFFFFFFFF 1 0 0 ?
How I calculate the amounts in Column G for all Rows? Kindly explain
Hello Subramanian!
I’m sorry but your task is not entirely clear to me. What result do you want to get? If you want to calculate the amount on line 2 in cell G2, then use the formula
= SUM (A1: F1)
I recommend an article on the SUM function.
Could you please describe it in more detail? Thank you!
hey, I am trying to find a formula that will multiply the value up to x by y, and over x by Z, example if the up to 10000 multiply by one, and everything above 10000 multiply by 2, what would be the best way to do that?
Hello!
Please try the following formula:
= IF(A1 > 10000),A1*2,A1*1)
Is there a way in Excel to put a number in a cell, and automatically have that number multiplied by 2 without deleting the formula, using a second sheet, or using a second cell??
Am item cost 100 per bag and the bag contains 3 pieces, how do I insert a formula if 4 bag and two pieces where sold?
Hi, I need to multiply one cell by another and add those totals all the way across my spread sheet. Similar to this =(B8*$B$4)+(C8*$C$4)+(D8*$D$4)+(E8*$E$4)+(H8*H$4) but much longer. Is there a formula or function where I can do this without typing each out?
Hi Kelly,
Here is the formula that should do the trick for you:
=(B8*$B4) + (C8*$C4) + (D8*$D4) + (E8*$E4) + (H8*$H4)
i want silver multification
2.145 weight
44.55 touch
2145*4455=9555
exel automatically last 5 come add one number for multification(*) how to incress last 8 number come Add one number
exg that come 9556
Can I use if function in multiplying the cells? Like if the value in the cells is >=40 then multiply the values in the cells
Is there a formula to calculate cells in sheet 2 with the same cell in sheet 1?
I am trying to figure out how to allocate travel cost of a worker according to the amount of time in a day they have spent in each category. Example:
Jack has 3 hours travel @ $50/hr. He has a total of 9 hours worked that day. 2 hours he spent on sales, 1 hour on administration and 2 hours on documentation. I want a formula that will multiple the travel time by his rate, turn the travel time into a percentage and be able to allocate his hours across the categories dependent on how many hours he worked in each category. I believe I first need to turn travel time into a percentage of the total hours that day and then multiple that percentage by the number of hours in each category, then multiple that number by rate. Wanted to have a formula so that I can do this daily for multiple workers.
Hi all,
I am looking for a bit of advice. I have created a spreadsheet to calculate the total cost of an order, comparing 3 different companies prices.
I have a drop down menu to select the type of equipment that we require and have added a sumif formula to automatically input the singular unit value of the selected equipment into the adjacent column. I also have a quantity column, I would like to be able to select the equipment type in the drop down box and have a formula to automatically multiply the unit cost by the quantity and input that value into the cell in place of the singular unit cost.
For example, I would like to order 5 packs of large gloves. I would select the large gloves in the drop down menu which would automatically input the unit value for 1 pack of gloves via the sumif formula into the next cell. I would then enter the quantity as '5' into the quantity column and I would like the formula to multiply the singular unit cost by 5 and automatically enter the total in place of the singular unit
Does anyone know how I can do this?
I hope this makes sense, I am happy to further explain if necessary.
Thank you so much, this was so helpful!!!
Write the formula using appropriate Excel syntax, that you would use in cell B2 which if copied across column B, C, D and E would populate the columns with the multiplication table of 2, 3, 4, 5 and 6
How do you multiply a cell value by the current month ?
Hi Bob,
Simply return the current month by nesting the TODAY() function inside MONTH, and then multiply by a cell. For example:
=A2*MONTH(TODAY())
I’m trying to divide column B by column C then multiplying that by column C. Column B is dollars and cents and I would like column D (the final product) to be dollars and cents also. Please help!
Is there a formula out there to multiply x by 5 and have it so I enter in x into the cell then it change to correct amount?
Trying to do a if d1 >2 then d3= d1*25.
any Ideas?
I need to calculate a 3 time markup for each individual price in a row not a column. For example, A1 through G1 multiplied by 3 times
3000 X 4 - 3% formula please
Hi,
Anyone know a formula that can multiple the "A" only? so 5*-3*4.. What if I had lots of As? See below 2 columns
Thanks,
A 5
B 4
C 2
D -4
A -3
A 4