Dears,
How do I make the formula to calculate one time bonuses when production reaches certain level.
e.g. When Production reaches 25000, I pay a bonus of 1 million when it reaches 50,000 I pay 2 million.
I used the following but it does not give me a one time bonus and pays every year till it reaches the next level.
=IF(AND(B15>=25000,B15<50000),1000,IF(AND(50000<=B15,B15<75000),2000,IF(B15>=75000,3000,0)))
Can any none help please?
Vijay
Hello Vijay,
Create a two column table. First column enter the starting level, 2nd column the bonus. like,
then use likeK L 0 0 25000 1000 50000 2000 etc..
=LOOKUP(B15,K:L)
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks