change value in column A if value in Col C =N

[vlree]

Is this possible without VBA?

If value in col C = N change value in col A = X

Thanks

 

[SkipVought]

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,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[AnotherHiggins]

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