Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Content via Secondary Formula
Hello... I was wondering if it were possible to have a formula that
evaluates the content of a cell and then change the values of another cell based on the criteria? Range A1 has the evaluation formula Range B1 has the data to evaluate Range Sheet2 A1 is changed per A1's Logic Range A1 = IF(B1="Yes",Sheet2!A1="OK",Sheet2!A1="") Thanks in Advance, Rob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Content via Secondary Formula
Don't worry about using B1 on the first sheet, instead put your IF function
into A1 on Sheet2, looking back at A1 on the other sheet. In A1 on Sheet2: =IF(Sheet1!A1="YES","OK","") "Rob" wrote: Hello... I was wondering if it were possible to have a formula that evaluates the content of a cell and then change the values of another cell based on the criteria? Range A1 has the evaluation formula Range B1 has the data to evaluate Range Sheet2 A1 is changed per A1's Logic Range A1 = IF(B1="Yes",Sheet2!A1="OK",Sheet2!A1="") Thanks in Advance, Rob |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Content via Secondary Formula
On Tue, 7 Jul 2009 04:28:01 -0700, Rob wrote:
Hello... I was wondering if it were possible to have a formula that evaluates the content of a cell and then change the values of another cell based on the criteria? Range A1 has the evaluation formula Range B1 has the data to evaluate Range Sheet2 A1 is changed per A1's Logic Range A1 = IF(B1="Yes",Sheet2!A1="OK",Sheet2!A1="") Thanks in Advance, Rob All that a formula can do is return a value. It cannot alter another cell. So the way to do this would be to have a formula in Sheet2!A1 that looks at Range A1 (or even at B1 directly). If you cannot have a formula in Sheet2!A1, but must have only a value, then you will need to use a VBA Sub. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to get formula content of a cell? | Excel Worksheet Functions | |||
Cell content differes from formula bar | Excel Discussion (Misc queries) | |||
Cell content / formula bar different | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |