ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   RANK Q (https://www.excelbanter.com/excel-discussion-misc-queries/187192-rank-q.html)

[email protected]

RANK Q
 
i hve a Q plz get me d solutn

project 1 project 2 project 3


xpctd rate 0.3
0.3 0.3

out flow 500000 800000 450000

inflow 1. 300000 135000 219000
2. 75000 148500
320000
3. 30000 163350
79000
4. 100000 179685 50000
5. 95000 188669.25 215000
6. 225000 198102.7125 300000

NPV 79987.22902 291664.3373 754872.1383

*IN DIS Q V HVE 2RANK D BEST PROJ OUT OF 3


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com