Compatability issue

O

oldjay

I have a workbook created in Excel 2003. I have opened this file in 2007. I
have saved it a with a .xlsm extension,

A formula in say A1 is =IF(B1="Y",2,1). It always equates to 2 even when B1
is blank. The function argument says B1="Y" is true even thou B1is blank.

Now if you create a new worksheet in this same workbook and copy the A1
formula to A1 on the new sheet it equate correctly.

If you save the file in 07 to the compatible with 97 -03 the original
formula equates correctly

I migh
 
M

Matthew Herbert

OldJay,

What is your calculation mode set to? If you are in a manual calculation
mode, then press F9 to recalculate the worksheet.

Best,

Matthew Herbert
 

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

Urgent 2
Scrabble Value calculation for Welsh words 0
Keeping whole formula constant to new workbook 1
Conditional Formatting macro: simple, but doesn't work 6
Time Tracking problem. 5
How do I reference cells in CF formula within loop 2
Compatability Checker Question 3
RE: MATCH and INDEX combination using multiple criteria? 1

Top