November 10, 2020
hi, i want to use the if condition when we have capping condition.
for E.g. :- we have Target & we have achievement & target achievement is capped @ 110%, t
Achievment:-100, then he get Payout @400 Rs / unit- 40000
Achievment is:- 90, Then no payout
Achievment is 120, Then i am not able to apply formula with all 3 condition ( as Achievment is capped at 110%)