Clearing a cell

[asabti]

I want to clear a cell of any information if a condition hols

so if cell B2=2 then clear cell B5

Thanks in Advance

[arthurbr]

Hi,
In B5 enter =if(b2=2,"",some other value)

[asabti]

good idea but i have cell B5 as an input cell so i can't put a forumula in there!

[arthurbr]

I think you'll have to resort to VBA then.
If you want I'll move this thread to the right forum

[asabti]

please do sir!