UNDELETE

[Fernando Duran]

I want to know if it's possible to set to zero a cell without erasing
the formula in that cell, when the user choose in another cell to do
that??/
thanxs

 

[Frank Kabel]

Hi
maybe something like
=IF(A1="erase","","other value")

 

[Fernando Duran]

I tried, it work in one way, clears, but when trying to go back..
nothing
=IF(E4="CARRERA","",+E43/100*0.8+6.5)

 

[Frank Kabel]

Hi
maybe you can explain with example data what you're trying to achieve

I'm not sure what you mean with 'going back'

 

[Fernando Duran]

Is ok. frank, is fixed, is working fine using your idea..

thanks