Home |
Search |
Today's Posts |
#1
|
|||
|
|||
REMOTE CELL FUNCTION
Is it possible to have a formula in one cell for example if A1 had a formula,
something like =IF(B1=2,C1,""), this formula copies the value from C1 if the value is true, is it possible to have A1 write in a formula or a value based on the result from the IF statement from A1 into C1 A1. IS THE FORMULA B1. IS THE VALUE C1. Is equal to whatever A1 says it is. Thanks in advance! Dan |
#2
|
|||
|
|||
No
you could put =A1 in C1 or you could write a macro to paste the value into C1, but you can not use a formula in one cell to change what is entered in another cell without code. "Dan" wrote: Is it possible to have a formula in one cell for example if A1 had a formula, something like =IF(B1=2,C1,""), this formula copies the value from C1 if the value is true, is it possible to have A1 write in a formula or a value based on the result from the IF statement from A1 into C1 A1. IS THE FORMULA B1. IS THE VALUE C1. Is equal to whatever A1 says it is. Thanks in advance! Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Using the MAX function with "constant increment" cell references | Excel Worksheet Functions | |||
Function to operate on ink linked to cell | Excel Worksheet Functions | |||
Function to return colour of formatted cell | Excel Worksheet Functions |