Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do i lock a cell so that its result doesnt change?
Basically in cell A1 a value of 1-5 will be entered, in cell B1 will be a value. Cell C1:C5 will list numbers 1-5 the problem is the formula results in D1:D5 ie D1 will contain the value B1 if A1 = 1 or D2 will contain the value B1 if A1 = 2 and so on. so if i enter value 1 in A1 and value 20 in B1 (which then should put the value of 20 in D1 how do i stop the value from D1 disappearing if i change A1 to 2? i have used the copy paste value but would rather automate it then having to repeat it every time |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula result does not match displayed result | Excel Worksheet Functions | |||
Formula Bar F9 Result differs from cell result??? | Excel Worksheet Functions | |||
lock cells based on formula result | Excel Discussion (Misc queries) | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Write the result of a formula only once then lock it | Excel Programming |