functions quit working

T

Toby John

=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?
 
F

Fred Smith

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
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Continues to move to the right 0
Subtraction Function using cells with other functions in them 2
Vlookup to reference offset 1
Sum every Nth Row (almost working) 2
LOOKUP vs IF programming question 6
"The object was saved in an invalid format and cannot be read." 0
Excel VBA Formula Help 4
How would I use one cell to look at two different vlookups? 4

Top