Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Calculating Value as per given threshold

1

Hello, 

I am bit new to excel and stuck to caluclate a value, below is the situation:

A                 B                C

threshold                     rate

0               20,000            0

20,001      60,000         2.43

60,001     120,000        2.18

120,001    240,000       1.94

240,001     480,000       1.70

480,001         +             1.46      

Total Units Sold:      700,000  

Given above are:

Colums A & B (merged) = Threshold

Column C = Rate for thresholds

If there are total 700,000 units sold how I can calculate value of it considering given threshold and calculate value of it as per threshold. Means, I want a formula which calculate value as per given threshlod for total units.

Any urgent help will be really appreciated.

excel
posted by: uarshad83 (rep: 2) on Thu Aug 10, 2017 at 12:22 pm
Answer
Discuss

Discussion

If this is a task from school you didn't understand the question. If this is a task from your job you didn't explain the question. Either way, with the information given I'm afraid there is no answer.
Start with saying what you want to calculate. Is it the value in column C? Then figure out word to explain how to calculate it. Nobody here knows what is "threshold" in your context. After you found the words to explain what needs to be calculated somebody might help you "translate" them into a formula that works in Excel.
Variatus (rep: 4889) Aug 10, '17 at 8:15 pm
Add to Discussion

Answers

0
Selected Answer

Hi Variatus, 

Really thankful for your guidance. I agree with you probably I remained unable to describe what I want. But let me share you that it have been resolved. In future, I'll try to describe in more effective way.

posted by: uarshad83 (rep: 2) on Thu Aug 17, 2017 at 10:20 am
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login