Results 1 to 4 of 4

Thread: Formula Assistance

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Member
    Join Date
    Apr 2011
    Posts
    69
    Rep Power
    15
    I have two set of formulas in H & I column and i want both of them give me same results.e.g column H has =IF(AND($C$2<>0,$E2<>0),IF(IF($B2="51",0,IF($A2="1 ",(($F2-$G2)*$D2%),$K2))<0,0,IF(AND($C2<>0,$E2<>0,IF($E2=0 ,0,IF($B2="51",0,IF($A2="1",(($F2-$G2)*$D2%),$K2)))),0))) with some more test but it gives false.

    thanks
    Attached Files Attached Files
    Last edited by excel_learner; 12-06-2011 at 10:08 AM.
    ----
    excel_learner
    (Using XL 2007 & 2010)

    -------Learning never stops!

Similar Threads

  1. Replies: 9
    Last Post: 03-13-2012, 01:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •