# multiplying cells without having to make new ones

#### lud

##### New Member
alrite, heres my idea. i am making up a nutritional diet plan for myself. i ha ve the columns split up into protein, carbs, fat, calories.. what i want to do is have something like a "Quantity" cell, where if i put in a certain #, it changes the value of the cells to whatever that original value, times the quantity value.. I dont want to have to make new cells, i just want the value in the original cell to get multiplied by the new quantity.
for ex..
original cell has 50 in it
then i put 5 in the quantity cell
and that original cell of 50 changes to 250

how do i do this? thanks.

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

#### XLGibbs

##### Well-known Member
You could do this, and just HIDE column B after your base number of 50 is there (assuming your base is for quantity of 1 all the time)
Book1
ABCD
1TotalCaloriesQuantity
250501
Sheet1

#### lud

##### New Member
but the only thing is, i have like 4 separate columns rite next to each other..
and it would get confusing if i had to do that like 8 times lol.. any alternatives?

#### XLGibbs

##### Well-known Member
Not really, in order to "do the math" you have to have the original number and the quantity and result in seperate cells unless you want VBA code to do it.

#### barry houdini

##### MrExcel MVP
Could you just "hard code" your original value, e.g. if the quantity cell is E1 you use the formula

=E1*50

#### XLGibbs

##### Well-known Member
Of course! My interpretation was that she had the original value and quantity already on the sheet, and was hoping to update the values without re-doing the whole thing...

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,167,835
Messages
5,855,909
Members
431,772
Latest member
dannyboi1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back