| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you have one cell alter another cell
For example: say I want cell A3 to do a logic test and if cell A1 i True then have it enter a 4 into cell A2. I don't want to place an formulas in cell A2 because if A1 is false then I want the user to b able to place their own amount into A2. Is this possible and if so ho do I do it. I though tthe formula for A3 would b =if(A1=TRUE,A2=4,A2="") but this doesnt work. Can anyone help me out? Thank - juniu ----------------------------------------------------------------------- Posted via http://www.mcse.m ----------------------------------------------------------------------- View this thread: http://www.mcse.ms/message601749.htm |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| alter column ref | Excel Discussion (Misc queries) | |||
| How to alter comments in a locked cell ? | Excel Worksheet Functions | |||
| Alter Text in 900 cell entries | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| how to alter cell format if cell contains text | Excel Worksheet Functions | |||
Threaded Mode
