2003 v. 2007
 

I have the same cell formula in a.xlsm workbook and in a .xls Compatibility
workbook.

=IF(AND($C$450,$C46="Clear"),1.35,IF($C$450,1,"" ))

The Computability workbook works correctly but the xlsm always indicates
1.35 as the result even when C46 is blank. The first term always evaluates as
true

I have copied the the formula from the .xls and also typed it in to the xlsm

Whats going on.