Get instant live expert help on I need help with formula to multiply in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I want to multiply formula, but the amount I want to multiply by is already a formula.
Solved by F. A. in 28 mins
I need assistance with a formula in excel please.
If Column A1 is 12.15 and I want to set a formula in column A2 = if A1 is = 9 or less than 9, then the value in A1 needs to be multiply with 48.00 but if A2 is more than 9, then 9 needs to be multiply with 48 + the difference (12.15 - 9 = 3.5) needs to be multiply with 1.5 x 48.
Solved by K. U. in 28 mins
I need formular to multiply columns on excel spreadsheet
Solved by M. Q. in 11 mins
Hi, i want to create a formula which allows a different calculation based on what volume is inputted. for example if a customer buys 500 units than my formula will multiply 90 per unit, however if i input 1300 units then my formula will multiply by 80 per unit, again if i input 2600, my formula will multiply by 57.14. My price-breaks are >500-<1100= multiply by 90 & >1300 - <1900 = multiply by 80 & >2600-<3500 = multiply by 57.14. I have managed to achieve this with IF for just 1 SUM but cannot work out how to get all three calculations working in 1 formula. please help :)
Solved by B. J. in 24 mins
I need an IF formula that says
If D2 = economy then multiply f2*50
IF d2 = premium then multiply f2*75
Solved by I. D. in 18 mins