Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function needed
I have 2 columns, if i change cell_1 in column_1, my cell_2 is going to
change the text from "T" to "A". how can i do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function needed
Can you provide any more information?
When you say cell_1 and column_1 do you mean Column A, Row 1 on the Excel grid? What kind of change will trigger the next cell to change from T to A? Spell out a few scenarios for us. -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "JJ" wrote: I have 2 columns, if i change cell_1 in column_1, my cell_2 is going to change the text from "T" to "A". how can i do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function needed
Change from what to what?
Or just a change? A1 contains the word "hoohah" In A2 enter =IF(A1="hoohah","T","A") Or did you have something more generic in mind? On any change at all you would need event code to update A2 rather than having a fixed formula as above. Post back if that's the case. BTW..............Excel syntax for cell references is Column/Row A1, A2, B1 etc. Get used to using that syntax rather than Cell_1 or Cell_2 Gord Dibben MS Excel MVP On Wed, 8 Apr 2009 16:02:01 -0700, JJ wrote: I have 2 columns, if i change cell_1 in column_1, my cell_2 is going to change the text from "T" to "A". how can i do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function needed | Excel Worksheet Functions | |||
Function Needed! Please Help! | Excel Worksheet Functions | |||
Help needed with function | Excel Worksheet Functions | |||
Function needed???? | Excel Worksheet Functions | |||
Help Needed With - If-Function | Excel Worksheet Functions |