ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   functions quit working (https://www.excelbanter.com/excel-worksheet-functions/257070-functions-quit-working.html)

Toby John

functions quit working
 
=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?

Fred Smith[_4_]

functions quit working
 
What does "stop working" mean?

Perhaps calculation is set to manual. Check your Excel options (the specific
instructions depend on the version you are using).

Regards,
Fred

"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?



David Biddulph[_2_]

functions quit working
 
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?





All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com