Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula not working in excel 2007
Sir,
Namaskar! I i just installed office 2007 and some formula is not working and retruning #N/A and some formula is returning 0 value. This formula is returing #N/A =IF(ISBLANK($C1063),"",IF(VLOOKUP($C1063,Inventory _List,9,0)<0,"INVALID SALE",VLOOKUP($C1063,Inventory_List,9,0))) and this is returning 0 vlaue =IF($C1067="","",IF(ISERROR(VLOOKUP($C1067,Invento ry_List,4,FALSE)),0,VLOOKUP($C1067,Inventory_List, 4,FALSE))) what should i change in excel 2007 or should i unstall office 2007 Hope you will soon solve my problem. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill color not working in excel 2007 | Excel Worksheet Functions | |||
Excel 2007 links not working | Excel Discussion (Misc queries) | |||
Excel 2007 Sort A-Z not working but did in 2000 | Excel Discussion (Misc queries) | |||
PAGE PREVIEW NOT WORKING PROPERLY IN EXCEL 2007 | Excel Worksheet Functions | |||
Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions |