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 value in A1 = 'C' …

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-column is the …

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 (e.g. chatGPT, …

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 before the …

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, WEEKNUM, …

Sep 13, 2017 · Handling multiple conditions in an IF formula. This article compares the three different methods. When you need to do a conditional calculation, the IF function is the answer. If <something …

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.

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 got a bit lost. I can …

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 rounded to nearest …

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