Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
207
Views
Topic starter
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
Target :-100
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%)
Posted : 11/11/2020 6:15 am
Hi Akshay,
Welcome to our forum. I'm not sure I fully understand your question, but give this formula a try:
=IF(A1<90,0,IF(A1<=110,400*A1,0))
Where cell A1 contains your achievement value.
Mynda
Posted : 12/11/2020 12:37 am
