If by "stopped working" you mean that it shows the formula, but not the
result, try changing the cell format from text to general and re-entering
the formula.
--
David Biddulph

"Toby John" <Toby wrote in message
...
=IF(D11="","",D10)
this function used to work fine then all of sudden it just stopped
working.
any one know what can cause this and what to do about it?