Hi Team, I need help on Percentage based on the condition.
Units Amount Rate Answer 851400 7821722 7.02 1,05,496.560 If A2 is >100000 and up to 1000000 then ((A2-100000)* 2%)*C2 discount on the amount Now for next up to 5000000 units percentage will be 1.5% and for units in excess of 5000000 up to 15000000 percent will be 1%. Also if the Units are under 100000 then the answer should be 0. I have also prepared the formula in Answer Column but need to correct the same Pfa attached sheet for your reference. Your help in this regard will be highly appreciated. Regards, Vik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/excel-macros/CANykk6XhZBHODo_hC-7AUvwoehz%2B389z%3DgBTapQxGgwH9BszFA%40mail.gmail.com.
Conditional based Percentage formula.xlsx
Description: MS-Excel 2007 spreadsheet
