Formulas quit---

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The workbook used almost everyday was fine until today.It opens with a
message box asking to "disable or enable macros". After enabling macros
(which is the only choice I have), all the formulas doesn't work.
I have try using the F9 and the Calculate Automatic methods as suggested by
some but still cannot work.
Examples of formulas: =IF(AND(ISNUMBER(F41)),F41/100*20,""),
=IF(AND(F40>69,F40<74),25,IF(AND(F40>74,F40<90),27,IF(F40>100,65,"")))
What is wrong?
Thanks.
 
Check the following:

Tools|Options|View

Do you have "Formulas" checked under window options? If so, uncheck it.
 

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

Conditional Array Formula 2
Countif and Sumif with refrence value a Cell on another Sheet in theWorkbook 3
Wrestling with fractions and dates. Knowledge of photography is helpful. 7
Do loop or For Next with data from cells 1
sumif and complex sum_range formulae 2
Error routine needed 1
How to use VLookup with a range of numbers? 3
IF formula, Partial word, SUM function as result 1

Back
Top