automatically multiply each cell entry by a number - MrExcel
Sep 13, 2004 · I'd like to be able to format certain cells so that after entering a numerical value, the entered value is multiplied by a number. My specific application involves entering numbers read from a gage during testing. The gage readings must be multiplied by a certain number (10^(-6)) to obtain the...
Multiply numbers with cells that contain text - MrExcel
Jan 10, 2022 · Hi all, I'm trying to multiply column E with column F, I've tried many different formulas but they don't seem to work and give a VALUE! error.
Automatically multiply a value & overwrite the result in same cell
Jun 28, 2016 · Hello I want to be able to enter a value into a cell (within a specified range if necessary) and have it automatically multiply by a particular cell and overwrite the original entry with the result so making it all happen within one cell. Like for …
Commanding a cell to multiply itself with a number - MrExcel
Jun 13, 2008 · I have a column with ratios, which I want to turn into percent, i.e. I want to multiply ever cell with 100. Is there an easier way to do this than to create a new column? Thanks!
Number Format times 100 | MrExcel Message Board
Mar 21, 2011 · How do you make a percentage displayed as (13.98%) to be displayed as -13.98 by just formatting the number (I don't want to have to multiply it by 100)?
Multiply All Cells in a Range by a number using VBA - MrExcel
May 23, 2008 · What I would like therefore is a way to use VBA to multiply all the cells in a range by 1000, then copy and paste them into a different range. The original value does not need to survive.
Multiply text string by number resulting in list - MrExcel
Jan 22, 2004 · Using Excel 2010... I have a list of names (text string) in a column (A) that have associated whole numbers in another column (B). What I would like to do is create a formula that multiplies the text string in cell A2 (for ex.) by the whole number in B2 and return a "list" of the text string in A2 equal to the whole number by which it is ...
Multiplication in Excel if cell contains greater than 0
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.
multiply dates by a number | MrExcel Message Board
Feb 18, 2008 · Greetings, I have been tasked to create a method to create a password by entering a date into a cell. My first step is to figure out how to multiply a date value to return a numeric value since a "date" is not a technically a number. For example if I enter in the date "10/03/15" into A1 and I...
If cell is positive, then multipy, if negative, then take this cell
May 16, 2018 · The same issue in reverse which might be the same formula. If cell C_ is negative, then E_ equals D_, but if C_ is positive, then F_ equals D_. Basically I have either a positive or negative value in cell C, cell D is a dollar amount, cell E is a dollar amount and cell F is a dollar amount as shown below.