Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change a number in a cell without effecting the formula?
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? |
#2
|
|||
|
|||
How do I change a number in a cell without effecting the formula?
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 "Celeste" wrote in message ... 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? |
#3
|
|||
|
|||
How do I change a number in a cell without effecting the formu
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. -- paul remove nospam for email addy! "Chip Pearson" wrote: 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 "Celeste" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change cell color if it is the lowest number of a group? | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions | |||
how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |