C chssundeep Member May 30, 2014 #1 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 Attachments Problem.xlsx Problem.xlsx 10 KB · Views: 7
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 Excel Ninja Staff member May 30, 2014 #2 Formula in cell D5: =MIN(35%*C5,MAX(0,G5-10000)) Formula in cell E5: =G5-SUM(C5:D5)
C chssundeep Member May 30, 2014 #3 Dear Luke Thank you very much for quick response and jet speed reply....... its working like a gem......
Dear Luke Thank you very much for quick response and jet speed reply....... its working like a gem......
C chssundeep Member May 31, 2014 #4 Dear Luke please extend your help in solving this Attachments Problem.xlsx Problem.xlsx 10.1 KB · Views: 9
Luke M Excel Ninja Staff member Jun 2, 2014 #5 See attached. Row 7 in your file appears to have an error...2% of 11,000 is 220, not 225. Attachments Problem Solved.xlsx Problem Solved.xlsx 10.5 KB · Views: 6
C chssundeep Member Jun 2, 2014 #6 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
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