*** The TPC Android application IS NOT OFFICIAL. Use it at your own risk! ***
Using the app GIVES THE DEVELOPER ACCESS TO YOUR LOGIN DETAILS.

Forum Topic

excel macro programming

  • from sir olayskie's formula: just added Find function. let us know if its working...

    =IF(LEFT(A1,3)="110",MID(A1,5,FIND("-",A1,5)-5),"")

    Kircchoffs, try mo rin pglaruan ang mga string functions. it will help u a lot in simple formulas like this one.
  • @olayskie and dodick

    thanks mga sir both working po sila ^_^
  • meron po bang parang crash course dito sa philippines about sa macro programming?
  • mga sir need your help po ulit para sa new project ko


  • =if(D2 = "x", E2, D2* E2)?
  • =if(D2 = "x", E2, D2* E2)?


    di po working sir. 3 po kasi yung variable, LEVEL, ITEM at QTY.

    anyway may tumulong na rin po saken sa ibang thread. ^_^

    =IF(AND(B2=1,D2="X")=TRUE,E2,IF(INDIRECT("D"&ROW()-1)="X",E2*INDIRECT("E"&ROW()-1),IF(INDIRECT("D"&ROW()-2)="X",E2*INDIRECT("E"&ROW()-2),IF(INDIRECT("D"&ROW()-3)="X",E2*INDIRECT("E"&ROW()-3),IF(INDIRECT("D"&ROW()-4)="X",E2*INDIRECT("E"&ROW()-4),IF(INDIRECT("D"&ROW()-5)="X",E2*INDIRECT("E"&ROW()-5),"array"))))))