multiplying cells without having to make new ones

lud

New Member
Joined
Dec 11, 2005
Messages
2
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
Joined
Feb 25, 2005
Messages
2,446
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
Joined
Dec 11, 2005
Messages
2
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
Joined
Feb 25, 2005
Messages
2,446
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
Joined
Mar 23, 2005
Messages
20,825
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
Joined
Feb 25, 2005
Messages
2,446
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...
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top