Dont know how to proceed with!!!

sinfulloyolite

Board Regular
Joined
May 8, 2008
Messages
79
Hello Board,

I have been trying to calculate as below:

<table style="border-collapse: collapse; width: 159pt;" border="0" cellpadding="0" cellspacing="0" width="212"><col style="width: 48pt;" width="64"> <col style="width: 63pt;" width="84"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; width: 48pt;" width="64" height="20">Brk Up</td> <td class="xl70" style="border-left: medium none; width: 63pt;" width="84"> %</td> <td class="xl69" style="width: 48pt;" width="64"> Total</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="border-top: medium none; height: 15pt;" align="right" height="20">30</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl69" style="border-top: medium none;" align="right">0</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl69" style="border-top: medium none; height: 15.75pt;" align="right" height="21">80</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">10</td> <td class="xl69" style="border-top: medium none;" align="right">8</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl69" style="border-top: medium none; height: 15.75pt;" align="right" height="21">120</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">20</td> <td class="xl69" style="border-top: medium none;" align="right">24</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="border-top: medium none; height: 15pt;" align="right" height="20">130</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">30</td> <td class="xl69" style="border-top: medium none;" align="right">39</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td class="xl69" style="border-top: medium none;" align="right">71</td> </tr> </tbody></table>

In column A I have the Brk up & Column B is the percentage on which it needs to be calculated & Column C will b the result after calculating as per the % given in B.

I need a formula which will give the direct end result when I enter 130 in cell A2 & in B2 it should be as 71 which u c see above.

The criteria will be as 0-50, 0%; 51-100, 10%; 101-120, 20%; 121 & above, 30%.

Could anyone help me out to form a perfect formula for this?

Thanks,
Prem
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Hey,

Thanks for your response.

But I get the result as 39 but I need it as 71 which is a sum of all the above Brk up...

could you help me out?
 
Upvote 0
Ok to be more clear,

It goes in this way if I enter 130 in A2, From 0-50 it is 0%; From 51-100 it is 10%; 101-150 it is 20%; 151 & above it is 30%

Since my value is 130, here 0-50 = 0, 51-100 = 5, 101-130 = 6... So total should be 11.

Guess this should be clear.

Thanks,
Prem
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,176
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top