srinath tantri
New Member
- Joined
- Dec 10, 2017
- Messages
- 12
Hello all,
Hope you are doing well today,
I have a project which is incomplete without an excel tracker with the provided conditions below, will any one be able to help me with it?
Assume the cell values as below information provided:
· B9 = Receipt amount
· I9 = Level of Graduation
· M9 = Grade Achieved
· Q9 = Claim amount
Claim amount (Q9) = 100% of receipt amount (B9) if Grade achieved (M9) =”A” and if Level of Graduation (I9) = “Under Graduated” maximum up to 11500 and
= “Post graduated” maximum up to 18500.
<tbody>
</tbody>
Claim amount (Q9) = 75% of receipt amount (B9) if Grade achieved (M9) = “B” and level of graduation (I9) = “Under Graduated” maximum up to 11500 and
= “Post graduated” maximum up to 18500.
<tbody>
</tbody>
Claim amount (Q9) = 0% of receipt amount (B9) if Grade achieved (M9) = “C”
<tbody>
</tbody>
Appreciate all your efforts and help in providing resolution for this tool in advance.
Do let me know in case you have anything else for me.
Thank you so much!
Hope you are doing well today,
I have a project which is incomplete without an excel tracker with the provided conditions below, will any one be able to help me with it?
Assume the cell values as below information provided:
· B9 = Receipt amount
· I9 = Level of Graduation
· M9 = Grade Achieved
· Q9 = Claim amount
Claim amount (Q9) = 100% of receipt amount (B9) if Grade achieved (M9) =”A” and if Level of Graduation (I9) = “Under Graduated” maximum up to 11500 and
= “Post graduated” maximum up to 18500.
Q9 = B9 (100%) if M9=”A” and if I9= “Under Graduated” then maximum amount = 11500 and I9= “Post Graduated” then maximum amount=18500. ------------Condition 1 |
<tbody>
</tbody>
Claim amount (Q9) = 75% of receipt amount (B9) if Grade achieved (M9) = “B” and level of graduation (I9) = “Under Graduated” maximum up to 11500 and
= “Post graduated” maximum up to 18500.
(Q9) = B9 (75%) if M9= “B” and if I9= “Under Graduated” then maximum amount = 11500 and I9= “Post Graduated” then maximum amount=18500. -----------Condition 2 |
<tbody>
</tbody>
Claim amount (Q9) = 0% of receipt amount (B9) if Grade achieved (M9) = “C”
(Q9) = B9 (0%) if M9=“C” |
<tbody>
</tbody>
Appreciate all your efforts and help in providing resolution for this tool in advance.
Do let me know in case you have anything else for me.
Thank you so much!