• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    EXCEL FORMULA

    urdu words..??? really more heads are better dan 1..:-)
  2. S

    EXCEL FORMULA

    =IF(C$40=0,IF(OR(C$4="IMPORT",C$4="LOCAL"),(C$13+80),(C$13+110)),0) ok.. i think i got it... waaaaaahhh... tnx a lot...:-)
  3. S

    EXCEL FORMULA

    hmmm... no.. if C40 =0, then it should execute d formula, otherwise it should giv me zero..
  4. S

    EXCEL FORMULA

    yes..
  5. S

    EXCEL FORMULA

    ok.. tnx..:-)
  6. S

    EXCEL FORMULA

    hi faseeh... i already sent u.. pls check ur email. tnx.
  7. S

    EXCEL FORMULA

    ok.. thanks a lot guys... but til now im not getting the correct one.. i have another option: in 1ST CELL say C11 i have ds formula =IF(AND(C$4="LOCAL",C$6="G.I. SHEET"),(C$13+80),0) now, on 2ND CELL, IF ON 1ST CELL THE RESULT IS 0, THEN...
  8. S

    EXCEL FORMULA

    Can u send me a test mail pls.. on my yahoo... am still not getting it.. maybe it will help if il send my worksheet so u can take a look at it.. karena_narvaez@yahoo.com. Thank you very much.
  9. S

    EXCEL FORMULA

    THE VALUE SHOULD GIVE ME AY13+80, OTHERWISE IT SHOULD GIVE ME AY+110 OR ZERO.. 2ND RESULT HAS 2 OPTION EITHER IT GIVES ME AY+110 OR IT WILL GIVE ME ZERO.
  10. S

    EXCEL FORMULA

    =IF(AND(AY$6<>"G.I. SHEET",(OR(AY$4="IMPORT",AY$4="LOCAL"))),(AY$13+80),(OR(AY$13+110,0))) this formula should give me a zero value but its giving me "TRUE" CAN SOMEBODY HELP ME PLS.
Back
Top