Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Paste function quit working drew Excel Discussion (Misc queries) 2 October 5th 09 08:07 AM
Hyperlinks quit working WLMPilot Excel Discussion (Misc queries) 0 March 11th 08 12:24 PM
control+arrow key quit working Scithe13 Excel Discussion (Misc queries) 2 January 11th 07 04:27 AM
my excel formulas have quit working MR Excel Worksheet Functions 5 January 26th 06 07:38 PM
calculations quit working CJ Excel Discussion (Misc queries) 24 November 17th 05 06:09 AM


All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"