Making the amount autofill

[chssundeep]

Dear Excel lovers,

Please help me to solve this

I am trying to solve using if function but ending up with circular error

Details are in the attached excel sheet

Thanks in advance for giving solution to my problem

 

[Luke M]

Formula in cell D5:
=MIN(35%*C5,MAX(0,G5-10000))

Formula in cell E5:
=G5-SUM(C5:D5)

 

[chssundeep]

Dear Luke

Thank you very much for quick response and jet speed reply.......

its working like a gem......

 

[chssundeep]

Dear Luke

please extend your help in solving this

 

[Luke M]

See attached. Row 7 in your file appears to have an error...2% of 11,000 is 220, not 225.

 

[chssundeep]

Thank you Thank you for the solution

Thanks A lottttttttttttttttttt

Really Really superbbbbbbbbb

Once again I thank you deep from my heart and really admire your thinking pattern