Clearing contents of adjacent cell.

[Trevasaurus]

Hey, I'm trying to clear the contents of a cell, based off of the contents of another cell.

I'm trying to work out a function like this: (IN CELL B2)

"=IF(LEN(C2)>5,Clearcontents(A2),"")"

I'd like to delete the contents of A2 if the length of C2 is over 5...or contains a ".".
I thought "clearcontents" might work b/c that phrase works in VBA.
Is there a function to get this done?

[protonLeah]

You can't use a formula in one cell to modify the contents of another.

[aydeegee]

If using VBA is not an option, then this will work (kind of)

Please Login or Register  to view this content.

=IF(LEN(C2)>5,"",[some sort of formula])

Please Login or Register  to view this content.

Regards

Alastair

[:) Sixthsense :)]

If using VBA is not an option, then this will work (kind of)

Please Login or Register  to view this content.

=IF(LEN(C2)>5,"",[some sort of formula])

Please Login or Register  to view this content.

Really the above will work?

[aydeegee]

Does for me.

Regards

Alastair

[:) Sixthsense :)]

@ aydeegee,

Please read the OP's description once again, since OP expecting B2 cell formula should clear A2 cell content

[aydeegee]

Ok - you're right - I thought that I had covered with the "sort of" !

Alastair

[:) Sixthsense :)]

It happens many times to me as well, but I go through the description twice when the MASTERS says NO

[Trevasaurus]

"[some sort of formula]", yea thanks, I was asking if there is an actual function that will delete another cell.