Počítám stravné, v každé zemi může být rozdílná cena na den.
Chci před výpočtem zadat že např. v DE jsem byl víc jak pět hodin to znamená 50€ jako stravné. Ve stejné tabulce a ve stejném řádku chci mít možnost zvolit si v jaké zemi jsem a zároveň tím měnit výsledek i měnu je to vůbec v Numbers možné? Prosím poraďte.
Patan77 wrote:
Change values in Numbers
I calculate the food allowance, the price per day may be different in each country.
I want to enter before the calculation that, for example, I was in DE for more than five hours, which means €50 as food allowance. In the same table and in the same row, I want to be able to choose which country I am in and at the same time change the result and the currency.
You need a table that lists the basic food allowance per country, like the one on the right.
Then in your expenses account report, the formula refers to that table based and the code you enter in the column beside it.
=XLOOKUP(B2,$Code,$Daily Allowance,"")
To create the drop-down list shown in the first picture, select all codes from the Allowances table and go to Format / Cell / Data Format / Pop-up Menu. Then copy the first cell (DE) to the first cell in the Report's Country column. Select the first entry (blank) then copy and paste that cell into the other cells under.
Patan77 wrote:
Change values in Numbers
I calculate the food allowance, the price per day may be different in each country.
I want to enter before the calculation that, for example, I was in DE for more than five hours, which means €50 as food allowance. In the same table and in the same row, I want to be able to choose which country I am in and at the same time change the result and the currency.
You need a table that lists the basic food allowance per country, like the one on the right.
Then in your expenses account report, the formula refers to that table based and the code you enter in the column beside it.
=XLOOKUP(B2,$Code,$Daily Allowance,"")
To create the drop-down list shown in the first picture, select all codes from the Allowances table and go to Format / Cell / Data Format / Pop-up Menu. Then copy the first cell (DE) to the first cell in the Report's Country column. Select the first entry (blank) then copy and paste that cell into the other cells under.
Změna hodnot v Numbers
