- Katılım
- 8 Temmuz 2011
- Mesajlar
- 2
- Excel Vers. ve Dili
- türkçe
Aşağıdaki tabloda I sutüna kadar verim var.
Burada Formül 1 kısmında H sutundaki satır F Stunun değeri amacım D sütündeki değerleri 24280 olacak şekilde sırasıyla formül 1 de "x" işareti koyamak.
Formül 2 karşılığa D sutünündaki değeri eşitlemek. 24280 Değerine ulaşınca son bulunan satıra kalan miktarı hesaplamak.
A | B | C | D | E | F | G | H | I | Formül 1 | Formül 2 |
241000401150030652 | 134 | 0 | 1078 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1078 |
241000401150030669 | 134 | 0 | 1052 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1052 |
241000401150030676 | 134 | 0 | 1074 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1074 |
241000401150030683 | 134 | 0 | 1034 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1034 |
241000401150030690 | 134 | 0 | 1017 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1017 |
241000401150030706 | 134 | 0 | 1097 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1097 |
241000401150030713 | 134 | 0 | 1036 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1036 |
241000401150030720 | 134 | 0 | 1031 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1031 |
241000401150030737 | 134 | 0 | 1083 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1083 |
241000401150030744 | 134 | 0 | 1067 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1067 |
241000401150030751 | 134 | 0 | 1068 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1068 |
241000401150030768 | 134 | 0 | 1062 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1062 |
241000401150030775 | 134 | 0 | 1066 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1066 |
241000401150030782 | 134 | 0 | 1089 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1089 |
241000401150030799 | 134 | 0 | 1093 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1093 |
241000401150030805 | 134 | 0 | 1065 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1065 |
241000401150030812 | 134 | 0 | 1050 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1050 |
241000401150030829 | 134 | 0 | 1095 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1095 |
241000401150030836 | 134 | 0 | 1094 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1094 |
241000401150030843 | 134 | 0 | 1078 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1078 |
241000401150030850 | 134 | 0 | 1084 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1084 |
241000401150030867 | 134 | 0 | 1081 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 1081 |
241000401150030874 | 134 | 0 | 1046 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | X | 786,00 |
241000401150030881 | 134 | 0 | 1068 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | 0 | |
241000401150030898 | 134 | 0 | 1019 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | 0 | |
241000401150030904 | 134 | 0 | 1055 | F | IRS2024000008260 | 24.280,00 | 24.280,00 | RYM30 | 0 |