Formula problem - Incorrect Option Setting?


C

carlboone

I have "inherited" a spreadsheet from someone else and am having
problem creating new formulas (there currently are no formulas in th
spreadsheet). I don't know if there is an option setting causing th
problem or if it is something else.

When I enter a formula, such as =IF(A1=1,"TRUE","FALSE"), it shows th
formula in the cell instead of the result. I have tried a couple o
things to figure out what's going on without much success.

If I enter the exact same formula in a new workbook, it behaves as
expect it to.

If I enter the exact same formula in a new worksheet within the curren
workbook, it doesn't function as expected.

I have compared the options between the two spreadsheets and don't se
anything different.

Does anyone know what I need to do to get the formulas to work
 
Ad

Advertisements

E

edessary

Before entering the formula into the cell change the format of the cell
from Text to General.
 
S

SteveG

Sounds like your view options.

Tools>Options>View Tab.

If the Window Options section option Formulas is checked, de-select it
and click on OK. You should now see the results of your formulas as
expected.


Does that help?

Steve
 
Ad

Advertisements

I

Ian G

You can also switch the view by pressing ctrl + ~ (usually the top-left
betton, next to 1.)

Ian G
 

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

Incorrect formula 6
Incorrect formula 8
Formula answers incorrect 1
Formula Addition incorrect 4
Formula rounding incorrectly but not consistently 2
Incorrect SUM 5
Incorrect Calculation 5
Incorrect Date 0

Top