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
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