| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name Assigned Formula Not Working
I am using Version 2007. The following formula, when inserted manually on the
sheet, does workout but when defined in a name like "Check" and inserted as =Check, in a cell, doesn't do so. Any particular reason and suggestion? "VM" is also defined as $F$4. =OR(AND(ISNUMBER(INDIRECT(ADDRESS(ROW(),COLUMN()-1))),OR(INDIRECT(ADDRESS(ROW(),COLUMN()-1))=VM,INDIRECT(ADDRESS(ROW(),COLUMN()-1))<=-VM)),INDIRECT(ADDRESS(ROW(),COLUMN()-1))="Old",INDIRECT(ADDRESS(ROW(),COLUMN()-1))="New") -- Best Regards, FARAZ A. QURESHI |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to color fill a cell if number over assigned value | Excel Worksheet Functions | |||
| assigned cell names | Excel Discussion (Misc queries) | |||
| Macro Assigned to a Button | Excel Discussion (Misc queries) | |||
| fourmla with result no less than assigned value | Excel Worksheet Functions | |||
Threaded Mode
