All things TrackVia!

Read, write, comment.

This is a public Category  publicRSS

Customer Story

    • Are U Expert using logical Formula
      Customer Story posted Jun 24 by Rakesh Kumar, last edited Jul 17 by Matt Strenz
      238 Views, 2 Comments
      Title:
      Are U Expert using logical Formula
      Summary:

      There will be using logical function as IF

      Target = 40 Cr.

      Acheivement = 31 Cr.

      Acheivement % = 77.50%

      Condition = ..................

      There are 4 condition

      1. if Acheivement is less than 95% than will be 0

      2. If Acheivement is greater than or equal to 95% but less than 100%, So it will be 90% of Acheivement

      3. If Acheivement is greater than or equal to 100% But less than or equal to 105%, So it will be equal to acheivement.

      4. If Acheivement is greater than 105 %, like ( 106% so on increased 1% will be extra added with multiply 1.5%)

      If have u answer or querry  pls email k_rakesh@mp.bhaskarnet.com

      From India

      Rakesh Kumar

      Dainik Bhaskar Ltd.

    Comments

    • This would involve using a nested IF formula to create an IF-THEN-ELSE comparison.  If we understand your question correctly for your desired calculation your formula would be as follows :

      if(Achievement/Target < .95, 0, if(Achievement/Target < 1, .90 * Achievement/Target, if( Achievement/Target < 1.05, Achievement/Target, Achievement/Target *1.5)))

      If this does not accomplish your desired end result please contact support at (800) 673-3302 to discuss.

    • There is attachement of my issued formula.

      Calculator.xls (16KB)