Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel opens two windows (2007 & 2003 format): I want only 2003. | Excel Discussion (Misc queries) | |||
2003 vba to hide two grouped charts, works in 2007 but not in 2003 | Excel Programming | |||
2003-2007 xlsm-2003 loses worksheet commandbutton functionality | Excel Programming | |||
2003--2007 recognize if i'm in 2007 or 2003 via code. | Excel Programming | |||
Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please | Excel Programming |