私はAmazonで購入した商品を日本で販売します。
そのためamazonの販売価格に数字をかけた金額をエクセルに表示したいのです。
例えば
amazonでの販売価格が１００ドルの場合
１ドル１００円の場合
アプリケーションで１．３と入力すると
13,000円になります。
１．５と入力すると
15,000円になります。
為替を変更できる機能と販売価格を変更できる機能を
搭載してください。
エクセルCSVの販売価格のコードは「price」です。
このコードに計算した価格が表示されるようにしてください。
Rating
60
Translation / English
- Posted at 02 Dec 2013 at 14:35
I buy products from Amazon and sell them in Japan.
So, I want my excel to display the amounts multipled the prices sold on Amazon.
For example, providing the price on Amazon is $100 each and 1$=100 yen, and entering a number of 1.3 on the application makes the total 13,000 yen.
If the number entered is 1.5, then the total is 15,000 yen.
I want such functions that allow me to change the exchange rates as well as the selling prices.
The code for the selling price on excel CSV is "price".
I want the calculation results to be displayed to the code.
[deleted user] likes this translation
So, I want my excel to display the amounts multipled the prices sold on Amazon.
For example, providing the price on Amazon is $100 each and 1$=100 yen, and entering a number of 1.3 on the application makes the total 13,000 yen.
If the number entered is 1.5, then the total is 15,000 yen.
I want such functions that allow me to change the exchange rates as well as the selling prices.
The code for the selling price on excel CSV is "price".
I want the calculation results to be displayed to the code.
★★★★☆ 4.0/1
![[deleted user]](https://secure.gravatar.com/avatar/695023b4efd563721d13716b1457bc73.png?d=identicon&mode=crop&r=PG&s=42)
Rating
52
Translation / English
- Posted at 02 Dec 2013 at 14:30
I want to sell items purchased at the Amazon in Japan.
I order to do so, I want to have the Excel spread sheet which shows the amount of the purchasing price from the Amazon multiplied by the certain constant.
For example, if the purchasing price at the Amazon is 100.0$ and the exchange rate is 1.00$ to 100.00JPY, entering the constant of 1.3 to Excel spread sheet automatically shows 13,000.00JPY.
If the constant is 1.5, the amount shown is 15,000.00JPY.
Please include the function to change the exchange rate and the constant.
The selling price code of Excel CSV file is “price”.
Please show the calculated selling price under this code.
[deleted user] likes this translation
I order to do so, I want to have the Excel spread sheet which shows the amount of the purchasing price from the Amazon multiplied by the certain constant.
For example, if the purchasing price at the Amazon is 100.0$ and the exchange rate is 1.00$ to 100.00JPY, entering the constant of 1.3 to Excel spread sheet automatically shows 13,000.00JPY.
If the constant is 1.5, the amount shown is 15,000.00JPY.
Please include the function to change the exchange rate and the constant.
The selling price code of Excel CSV file is “price”.
Please show the calculated selling price under this code.
1$ →$1