How do I change a number in a cell without effecting the formula?

G

Guest

I want to edit the info in a cell like change the number from 1 to 2 without
effecting the formula in the cell. Can that be done?
 
C

Chip Pearson

A cell can contain either a constant, static, value or a formula,
not both. If it contains a formula, you must write the formula to
return the desired result.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
G

Guest

if it is always the same number within the formula that changes you could
have the number in a seperate cell and the formula would always calculate
with the newest number,ie instead of 4*3 in a1 which you change to 4*2 or
4*5,you could have =4*b1 in a1 and type your new number in b1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell format -> remove cell format pattern without effecting colors 1
Excel Formatting 4
How to change cell width w/o effecting other rows 1
Cell Copying Problem 4
How do I make 2 cells become one without changing column size 9
sizing different cells in same column 2
Change Color of cell 3
Can you resize a column... 1

Top