Nested If For specific Criteria

As this is an Assignment, rather than do the solution for you , lets help a little (other members may provide a solution, but i prefer to help so you learn, which is the point of an assignment, as i'm not doing the assignment myself and wont be available for any exams)

What have you tried so far , please show the Nested IF you have created so far , and why you think its not working as required

I understand

This is urgent and I am not able to figure it out how to write it.

But this is a free forum with volunteers , so sometimes answers may take a while

If Target achieved is between 40 to 100%; 10% of Sale Amount is paid
If Target achieved is more than 100%; 15% is paid as bonus + 5,000 as Promotion bonus

you have worked out the % achieved, and so can apply the %
so the Bonus is just adding on that amount
(Achieved*0.15) + Bonus
If the % is based on the achieved value

Look at Q3 and work out % in column F. This is value you need to test in the IF formula.

Ok,
so you have the correct order < and use of <=
but the question is in part 2 -

10% of Sale Amount is paid

Not exactly well worded question - as thats the only part that says whats the % based on

So you need to find the % of the sales amount achieved
So its not than 40% , you need to calculate what the % is
so whats % of the sales target achieved - Actual Sales v target sales as a % in column F

for example
if(%targetachieved<40%,5

this provide a 5
but you need 5% of sales Achieved

Not exactly well worded question - as thats the only part that says whats the % based on

@Etaf: don't be confused by the Sales Achieved: this was me working blind! All that is required (I think!) is the commission % in column G of Q3 tab.

OK, not how i read it
anyway
So you need to work out the % Target achieved in column F
and then you can use your formula

as JohnTopley mentioned in post 4

ignoring the excel function for now
How would you calculate a % based on 2 values - target number v achieved number , then apply with cells reference

you need to work out what 15% is of the sales achieved
sales achivied * 15% and then add 5000 - remember excel does calculations in a certain order
so brackets will be necessary
hence why I thought the question needed to see the actual amount of commission paid in G , rather than a percentage due
But as i say poorly worded, and i maybe wrong , which would make it more complicates text (15 + 5,0000)

thought i had answered further, must have missed actually posting

how would you calculate a % based on 2 values ? normal % calc ignore Excel for now - then once you have a formula for % apply into excel using cell references
thats what you need to work out - what % has been achieved and then work out the commission payment

@nikhil_pande

We do not do your homework for you. If you have made progress and have a specific question about an Excel feature that is giving you trouble, we are happy to help. But please do not post your assignment and ask us to complete it for you, tell you how to get started, or advise what approach to take. That is what you are supposed to be learning in your class.

It is not technically against our rules so I have not closed your thread but please do not just throw a file at us, and expect us to do it for you.