Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
change value in column A if value in Col C =N
- Thread starter vlree
- Start date
SkipVought
Programmer
Hi,
A spreasheet function CANNOT CHANGE ANYTHING!
A function merely returns a value.
So you could have ANOTHER column that would be
[tt]
=if(C1="N","X",A1)
[/tt]
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
A spreasheet function CANNOT CHANGE ANYTHING!
A function merely returns a value.
So you could have ANOTHER column that would be
[tt]
=if(C1="N","X",A1)
[/tt]
Skip,
[sub]
[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.Small Medium @ Large!
[/sub]
AnotherHiggins
Technical User
like this?
[COLOR=blue white]=if(c1="n","x","")[/color]
Place the formula in A1.
John
You try to concentrate while staring down the barrel of a loaded Thnikaman.
-Strong Bad
To get the best answers fast, please read faq181-2886
[COLOR=blue white]=if(c1="n","x","")[/color]
Place the formula in A1.
John
You try to concentrate while staring down the barrel of a loaded Thnikaman.
-Strong Bad
To get the best answers fast, please read faq181-2886
- Status
Similar threads
- Locked
- Question