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.
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.