Jul 24, 2013 · Greetings, I am trying to find a formula that will allow me to do the following: If the value in A1 = 'A' then multiply B1 by .2 If the value in A1 = 'B' then multiply B1 by .15 If the …

Jun 2, 2018 · Good Evening, today I came across the following problem: Say we have a table where the a-column is for example the color of a car, the b-column who sold the car and the c …

Dec 15, 2016 · Re: Using VLOOKUP to retrieve number and multiply it by another value It's the hourly rate column on sheet 2 that is the problem. You have added a dollar sign and spaces …

Jul 26, 2021 · Forum Microsoft Office Application Help - Excel Help forum Excel Formulas & Functions [SOLVED] My multiply formula is not working, for two numbers The use of AI tools …

Mar 1, 2007 · multiply and round in one equation I need to take a number, multiply it by a precentage, & then round it to the nearest multiple of 5. ex: A1=142.5 B2=A1*50%, (then …

May 18, 2017 · If the phrase appears, I want it to multiply the corresponding cells in B & C and add them to each other for the total Floor Area of all the 1B2Ps. I tried looking at arrays but I …

Oct 28, 2021 · Re: PRODUCT function not working So I just learned that Excel treats cells as text when there is a particular function being used. The formula in that cell uses IF, VLOOKUP, …

Feb 16, 2002 · Is there a ProductIf command in Excel. I need to use the same function as SumIf but instead of adding, I need to multiply instead.

Nov 9, 2011 · VBA function to multiply two numbers based on reference/location bpsny01 Jan 8, 2015 B

Aug 29, 2015 · Multiply based on criteria Hi Im trying to make a formula that will multiply all numbers in an area based on a criteria, for instance multiply the numbers in column B in the …