Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2021, 08:26 AM
jocky6688 jocky6688 is offline Need Conditional based percentage formula! Windows 10 Need Conditional based percentage formula! Office 2019
Novice
Need Conditional based percentage formula!
 
Join Date: Mar 2021
Posts: 2
jocky6688 is on a distinguished road
Default 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,
Attached Files
File Type: xlsx Discount (1) (2).xlsx (11.9 KB, 2 views)
Reply With Quote
  #2  
Old 03-14-2021, 01:16 PM
Purfleet Purfleet is offline Need Conditional based percentage formula! Windows 10 Need Conditional based percentage formula! Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 335
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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
Reply With Quote
  #3  
Old 03-14-2021, 09:27 PM
jocky6688 jocky6688 is offline Need Conditional based percentage formula! Windows 10 Need Conditional based percentage formula! Office 2019
Novice
Need Conditional based percentage formula!
 
Join Date: Mar 2021
Posts: 2
jocky6688 is on a distinguished road
Default

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.
Attached Files
File Type: xlsx Discount (1) (2).xlsx (12.2 KB, 4 views)
Reply With Quote
  #4  
Old 03-14-2021, 09:37 PM
Purfleet Purfleet is offline Need Conditional based percentage formula! Windows 10 Need Conditional based percentage formula! Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 335
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Sorry i still dont understand, what is the 851400 in relation to the 960918+485298+5976828+-147024?

Quote:
100000 2% 2000
400000 1.50% 6000
351400 1% 3514
Reply With Quote
  #5  
Old 03-15-2021, 12:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need Conditional based percentage formula! Windows 7 64bit Need Conditional based percentage formula! Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,484
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

BTW, do not use merged cells. They are nothing but trouble
Reply With Quote
  #6  
Old 03-15-2021, 12:35 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need Conditional based percentage formula! Windows 7 64bit Need Conditional based percentage formula! Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,484
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Conditional based percentage formula! 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft