hi, i'm a s/w developer. i got a project to convert excel sheet to webpage type..
the problem is i don't know the logic's and function of excel. rite now i'm face with three issue.. abt iserror and lookup function and the other one is which is inside the iserror.
will show u the function here..
IF(ISERROR(DB(DB12,DI12,DJ12,$FN$11)),0,ROUND(DB(DB12,DI12,DJ12,$F$11),2)
HERE WHAT IS IERROR AND THE WITHIN THE DB(BRACES)..
NEXT IS
LOOKUP(DK12+1,$DL$11:$GW$11,DL12:GW12)
CAN ANY ONE HELP PLEASE
Bookmarks