#1
|
|||
|
|||
Need Conditional based percentage formula!
Hi Team,
I need conditional based formula to calculate the Discount value based on units, Kindly find the attached File for your reference and detailed understanding of requirement. Regards, |
#2
|
|||
|
|||
The numbers you note in the arrow are not in the speadsheet, can you clarify at what point what discounts stops and correct the numbers?
also take out the commas in the numbers as they are in the wrong place and very misleading |
#3
|
|||
|
|||
Hi Purfleet,
Thanks for the suggestion, PFA modified excel sheet, along with suggested changes. I have also managed to assign formula in E9 cell, However it's not working and shows error. Hence request you to kindly suggest the suitable solution on the same. |
#4
|
|||
|
|||
Sorry i still dont understand, what is the 851400 in relation to the 960918+485298+5976828+-147024?
Quote:
|
#5
|
||||
|
||||
BTW, do not use merged cells. They are nothing but trouble
|
#6
|
||||
|
||||
Cross-posted at: https://www.excelguru.ca/forums/showthread.php?11086-Need-Conditional-based-percentage-formula!
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Percentage Formula | kideal | Excel | 7 | 06-08-2018 05:19 AM |
Percentage calculations based on if over or under | mercmonster | Excel | 2 | 01-06-2018 07:06 AM |
percentage calculation formula | yoyo4 | Excel | 10 | 11-15-2017 11:44 AM |
What is the formula for getting the percentage for time | phoenix666! | Excel | 1 | 07-29-2016 08:18 AM |
Conditional formatting using a formula that will result in different colors based on dates | 19z | Excel | 3 | 05-28-2015 11:39 AM |