Fatura 2

WEBVTT 00:00:00.029 --> 00:00:08.299 Hallo Freunde, in diesem Teil unseres Videos werden wir mit dem 6. Eintrag der Pohatur-Datei fortfahren. 00:00:08.820 --> 00:00:10.061 Wenn ihr bereit seid, lasst uns beginnen. 00:00:10.742 --> 00:00:15.608 Hier wurde uns gebeten, eine Formel einzugeben, die die C3-C4-Zelle zu C5 addiert. 00:00:16.600 --> 00:00:20.845 Um dies zu erreichen, finden wir zuerst unseren C5-Wert. 00:00:21.585 --> 00:00:27.992 Wie ihr wisst, ist es eine der logischsten Optionen, die Schaltfläche für die automatische Summe zu verwenden, um diese Addition durchzuführen. 00:00:28.612 --> 00:00:32.636 Wenn ich das hier addiere und auf Enter drücke, erhalte ich das Ergebnis. 00:00:33.978 --> 00:00:35.880 Das haben wir erfolgreich abgeschlossen. 00:00:36.720 --> 00:00:43.303 Gebt eine Formel ein, die die Zelle C6 mit den Zellen C5 und A5 multipliziert. 00:00:43.884 --> 00:00:48.906 Wir sollen C5 mit A5 multiplizieren. 00:00:49.526 --> 00:00:51.667 Dafür schreibe ich die Gleichheitszeichen hierher. 00:00:52.367 --> 00:00:54.649 Dann C5. 00:00:56.601 --> 00:01:03.548 Ich wollte eine Multiplikation durchführen, also habe ich die Stern-Taste auf meiner Tastatur verwendet. 00:01:03.809 --> 00:01:07.452 Dann habe ich die %20 hier eingegeben und Enter gedrückt. 00:01:08.313 --> 00:01:12.057 Wir haben also die Mehrwertsteuer des Nettobetrags berechnet. 00:01:12.718 --> 00:01:17.203 Wie ihr sehen könnt, haben wir auch diesen Schritt erfolgreich abgeschlossen. 00:01:17.983 --> 00:01:19.084 Schauen wir uns als Nächstes an. 00:01:19.825 --> 00:01:24.668 Gebt eine Formel ein, die die Zellen C5 und C6 zu Zelle C7 addiert. 00:01:26.049 --> 00:01:32.093 Wenn ich hierher komme und wieder "Gesamt" sage, muss ich diesen Bereich mit meiner Hand auswählen. 00:01:33.970 --> 00:01:36.993 Dann, wenn ich Enter drücke, gibt es mir das Bruttoergebnis. 00:01:37.133 --> 00:01:37.433 Erledigt. 00:01:38.775 --> 00:01:41.316 Wir haben diesen Teil auch leicht erledigt. 00:01:41.977 --> 00:01:49.123 Die nächste Frage ist, eine Formel einzugeben, die die Zelle C8 mit der Zelle C7 multipliziert und die Zelle A8. 00:01:50.384 --> 00:02:04.006 Hier ist es wieder fast dasselbe wie die Operation, die wir gerade oben gemacht haben, das %3-Malzeichen auf meiner Tastatur und wenn ich das Bruttoergebnis hier mit dem Sternsymbol multipliziere, gibt es mir auch das 00:02:04.026 --> 00:02:04.766 Ergebnis. 00:02:06.087 --> 00:02:14.511 Was wir hier tun müssen, ist den Betrag des Ergebnisses vom Bruttoergebnis abzuziehen, um den zu zahlenden Betrag zu bestimmen. 00:02:15.352 --> 00:02:18.193 An diesem Punkt fordert es uns auch im letzten Schritt dazu auf. 00:02:18.934 --> 00:02:21.055 Also müssen wir hier gleich machen. 00:02:23.156 --> 00:02:29.861 Ich habe das Bruttoergebnis minus den Betrag der Zelle ausgewählt und dann außerhalb von Enter gedrückt. 00:02:30.361 --> 00:02:34.203 Es hat den zu zahlenden Betrag für uns vorbereitet. 00:02:34.303 --> 00:02:34.684 Erledigt. 00:02:35.724 --> 00:02:36.845 Das waren unsere Schritte. 00:02:37.445 --> 00:02:38.266 Ich wünsche Ihnen viel Erfolg. 00:02:38.546 --> 00:02:38.866 Schönen Tag.

WEBVTT 00:00:00.029 --> 00:00:08.299 Hello friends, in this part of our video, we will continue from the 6th transaction of the pohatur transactions file. 00:00:08.820 --> 00:00:10.061 If you are ready, let's begin. 00:00:10.742 --> 00:00:15.608 Here, we were asked to enter a formula that sums up the C3-C4 century of the C5 suspicion. 00:00:16.600 --> 00:00:20.845 To do this, first we find our C5 future. 00:00:21.585 --> 00:00:27.992 As you know, using the auto sum button is one of the most logical options to make this sum happen. 00:00:28.612 --> 00:00:32.636 When I sum like this, when I press Enter, it gave me the total. 00:00:33.978 --> 00:00:35.880 We have successfully completed this. 00:00:36.720 --> 00:00:43.303 Enter a formula that multiplies cell C6 by cells C5 and A5. 00:00:43.884 --> 00:00:48.906 We were asked to multiply C5 and A5. 00:00:49.526 --> 00:00:51.667 I write the equals sign here for this. 00:00:52.367 --> 00:00:54.649 Then C5. 00:00:56.601 --> 00:01:03.548 I wanted to do a star multiplication operation because I used the star key on my keyboard, which symbolizes multiplication. 00:01:03.809 --> 00:01:07.452 Then I pressed Enter after taking the %20 value here. 00:01:08.313 --> 00:01:12.057 We have calculated the VAT of the net total here. 00:01:12.718 --> 00:01:17.203 As you can see, we have completed this stage together. 00:01:17.983 --> 00:01:19.084 Let's look at the next one. 00:01:19.825 --> 00:01:24.668 Enter a formula that sums up cells C5 and C6 in cell C7. 00:01:26.049 --> 00:01:32.093 When I come here and say total again, I have to select this range with my hand. 00:01:33.970 --> 00:01:36.993 Then when I press enter, it gives me the gross total. 00:01:37.133 --> 00:01:37.433 Done. 00:01:38.775 --> 00:01:41.316 We easily handled this part as well. 00:01:41.977 --> 00:01:49.123 The next question is to enter a formula that multiplies cell C8 with C7 and A8. 00:01:50.384 --> 00:02:04.006 Again, here, almost the same as the operation we did above, when I press the star symbol on my keyboard for %3 multiplication and multiply the gross total here, it gives me the desired amount. 00:02:04.026 --> 00:02:04.766 It provided the amount. 00:02:06.087 --> 00:02:14.511 What we need to do here is to determine the payment amount to be made by subtracting the desired amount from the gross total. 00:02:15.352 --> 00:02:18.193 At this point, we are also asked for this in the final step. 00:02:18.934 --> 00:02:21.055 So what we need to do here is equal. 00:02:23.156 --> 00:02:29.861 I selected gross total minus the desired amount cell and then pressed Enter. 00:02:30.361 --> 00:02:34.203 It prepared the payment amount to be made. 00:02:34.303 --> 00:02:34.684 Given. 00:02:35.724 --> 00:02:36.845 That's all for our operations. 00:02:37.445 --> 00:02:38.266 I wish you success. 00:02:38.546 --> 00:02:38.866 Have a nice day.

WEBVTT 00:00:00.029 --> 00:00:08.299 Merhaba arkadaşlar, videomuzun bu kısmında pohatur alışımları dosyasının 6. alışımından devam edeceğiz. 00:00:08.820 --> 00:00:10.061 Hazırsanız gelin başlayalım. 00:00:10.742 --> 00:00:15.608 Bize burada C5 şüphesine C3-C4 yüzyaralığını toplayan bir formül girilmesi istenmiş. 00:00:16.600 --> 00:00:20.845 Bunu yapabilmek için öncelikle C5 futürümüzü buluyoruz. 00:00:21.585 --> 00:00:27.992 Bildiğiniz üzere bu toplamı gerçekleşmek için otomatik toplam butonunu kullanmak en mantıklı seçeneklerden bir tanesi. 00:00:28.612 --> 00:00:32.636 Şöyle topladığım zaman, Entra bastığım zaman toplamını bana vermiş oldu. 00:00:33.978 --> 00:00:35.880 Bunu başarıyla tamamladık. 00:00:36.720 --> 00:00:43.303 C6 hücresini C5 ile A5 hücrelerini çarpan bir formül gelin. 00:00:43.884 --> 00:00:48.906 Bizden C5 ile A5'i çarpmamızı istemiş. 00:00:49.526 --> 00:00:51.667 Bunun için bu bölgeye eşitleri yazıyorum. 00:00:52.367 --> 00:00:54.649 Ardından C5. 00:00:56.601 --> 00:01:03.548 Yıldız çarpım işlemi yapmak istedim çünkü klavyemdeki yıldız yani çarpımı sembolize eden tuşu kullandım. 00:01:03.809 --> 00:01:07.452 Ardından buradaki %20 değerini alarak enter tuşuna bastım. 00:01:08.313 --> 00:01:12.057 Biz burada net toplamın kdv'sini hesaplamış olduk. 00:01:12.718 --> 00:01:17.203 Gördüğünüz üzere bu aşamayı da tamamlamış olduk hep beraber. 00:01:17.983 --> 00:01:19.084 Gelin bir sonrakine bakalım. 00:01:19.825 --> 00:01:24.668 C7 hücresine C5 ile C6 hücrelerini toplayan bir formül girin. 00:01:26.049 --> 00:01:32.093 Hemen buraya gelip yine toplam dediğimde bu aralığı eli ile seçmem gerekir. 00:01:33.970 --> 00:01:36.993 Ardından enter'e bastığında da bürüt toplamı bana vermiş. 00:01:37.133 --> 00:01:37.433 Oldu. 00:01:38.775 --> 00:01:41.316 Bu kısmı da kolayca hallettik. 00:01:41.977 --> 00:01:49.123 Bir sonraki soru da C8 hücresini C7 ile A8 hücresini çarpan bir formül girmek. 00:01:50.384 --> 00:02:04.006 Yine burada az önce yukarıda yaptığımız işlemi neredeyse aynısı olan %3 çarpım klavyemdeki yıldız sembolü ve Buradaki bürüt toplamı çarptığımda da ist 00:02:04.026 --> 00:02:04.766 kontoyu vermiş oldu. 00:02:06.087 --> 00:02:14.511 Biz burada yapmamız gereken şey ist kontu miktarını bürüt toplamından çıkararak yapılması gereken ödeme tutarını belirlemek. 00:02:15.352 --> 00:02:18.193 Bu noktada bizde son aşamada da bunu talep ediyor. 00:02:18.934 --> 00:02:21.055 Yani burada yapmamız gereken eşittir. 00:02:23.156 --> 00:02:29.861 Bürüt toplam eksi ist kontu Hüresini seçtim ve ardından Enter dışına bastım. 00:02:30.361 --> 00:02:34.203 Bize yapılması gereken ödeme tutarını hazırladı. 00:02:34.303 --> 00:02:34.684 Verdi. 00:02:35.724 --> 00:02:36.845 İşlemlerimiz bu kadardı. 00:02:37.445 --> 00:02:38.266 Başarılar dilerim. 00:02:38.546 --> 00:02:38.866 İyi günler.