Adres mieszany: ceny z różnymi stawkami VAT

Adresowanie komórek i funkcje matematyczne - Arkusz kalkulacyjny w liceum i technikum (sheet)

Ceny netto są w kolumnie A, stawki VAT w wierszu 1. Formuła w `B2` to `=ZAOKR($A2*(1+B$1);2)`: `$A2` zawsze bierze cenę z kolumny A, `B$1` zawsze stawkę z wiersza 1. Ta jedna formuła skopiowana na cały obszar liczy wszystkie ceny brutto.

{"sheets":[{"name":"Arkusz1","cells":{"A1":"Netto","B1":"5%","C1":"8%","D1":"23%","A2":"10","A3":"24,99","A4":"99","A5":"149,5","B2":"=ZAOKR($A2*(1+B$1);2)","C2":"=ZAOKR($A2*(1+C$1);2)","D2":"=ZAOKR($A2*(1+D$1);2)","B3":"=ZAOKR($A3*(1+B$1);2)","C3":"=ZAOKR($A3*(1+C$1);2)","D3":"=ZAOKR($A3*(1+D$1);2)","B4":"=ZAOKR($A4*(1+B$1);2)","C4":"=ZAOKR($A4*(1+C$1);2)","D4":"=ZAOKR($A4*(1+D$1);2)","B5":"=ZAOKR($A5*(1+B$1);2)","C5":"=ZAOKR($A5*(1+C$1);2)","D5":"=ZAOKR($A5*(1+D$1);2)"},"formats":{"A1":{"bold":true,"fill":"#e0e7ff"},"B1":{"bold":true,"fill":"#e0e7ff"},"C1":{"bold":true,"fill":"#e0e7ff"},"D1":{"bold":true,"fill":"#e0e7ff"},"A2":{"num":"currency"},"B2":{"num":"currency"},"C2":{"num":"currency"},"D2":{"num":"currency"},"A3":{"num":"currency"},"B3":{"num":"currency"},"C3":{"num":"currency"},"D3":{"num":"currency"},"A4":{"num":"currency"},"B4":{"num":"currency"},"C4":{"num":"currency"},"D4":{"num":"currency"},"A5":{"num":"currency"},"B5":{"num":"currency"},"C5":{"num":"currency"},"D5":{"num":"currency"}}}]}

Ładowanie interaktywnego edytora... Jeśli się nie pojawi, włącz JavaScript.

Wszystkie lekcje kursu Arkusz kalkulacyjny w liceum i technikum·Zaloguj się, aby zapisać postęp na koncie.