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' …

Apr 19, 2022 · How can I get excel to round down to 2 decimal places when multiplying? I have a $ amount in column C, and then in column D I need to multiply the value in C by 1.4. So for example, if …

Mar 31, 2010 · I figure that it has something to do with a rounding issue. Can anyone give me an example formula of how to multiply a column X a percentage & round off the resulting number to 2 …

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 …

May 4, 2018 · Hello, Probably simple question here, but I am struggling with SUMIFS and SUMPRODUCT so I am reaching out for help. I have 3 columns: Two have values that need to be …

Aug 6, 2010 · Hi there, My question is as follows: I have data which I need to divide, then multiply by a percentage. For example: I wish to divide A1 by B1, then multiply this total by a percentage in C1. …

May 18, 2017 · Live Online Excel Training for Your Team from MrExcel. Bring MrExcel to your people. Two hours. High-impact. Zero travel. Click here for details.

May 13, 2022 · But I just want to learn if there is a formula to firstly, check if the cell is greater than 0 and then multiply if its greater than 0. After that having a total sum at the end in the Total Price cell.

Apr 27, 2006 · When multiplying two cells one with cell with a formula: = ( (PI ()* ( (A2/2)^2))*B2) cell formated to a number decimal (1). The other cell has a constant...

Oct 8, 2002 · Is there a single formula in cell B2 which can be copied across and down to create a multiplication table?