All things TrackVia!
Read, write, comment.
Customer Story
Are U Expert using logical Formula
652 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.